New features added to SQL Prompt Watch now.

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

  • 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.