How can we help you today? How can we help you today?

No support for filtered nonclustered columnstore index

Hi Redgate team,

it seems that there is no intellisense for the WHERE in a filtered columnstore index.

CREATE NONCLUSTERED COLUMNSTORE INDEX NCI_SalesOrderHeader_RevisionNumber_FLTR
ON Sales.SalesOrderHeader (RevisionNumber)
WHERE RevisionNumber = -1;
GO

Would be nice to see this in the next release - thanks!

Torsten
FoRG and MVP
torsten.strauss
0

Comments

1 comment

Sort by
  • Jessica R

    Hi Torsten,

    Thanks for reporting this!

    Our developers are now aware of this issue. The fix is not in the road map at the moment, but we will post here if there are any changes.



    Jessica R
    0

Add comment

Please sign in to leave a comment.