What are the challenges you face when working across database platforms? Take the survey
Options

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

Answers

  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4

    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.