Options
No support for filtered nonclustered columnstore index
torsten.strauss
Friend of Redgate › Posts: 266 Silver 3
in SQL Prompt
Hi Redgate team,
it seems that there is no intellisense for the WHERE in a filtered columnstore index.
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
Would be nice to see this in the next release - thanks!
Torsten
FoRG and MVP
Tagged:
Answers
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?