No support for filtered nonclustered columnstore index

torsten.strauss

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

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.