Home Dashboard Directory Help
Search

CREATE "FILTERED" COLUMNSTORE INDEX by Wim SQL Server


Status: 

Active


3
0
Sign in
to vote
Type: Suggestion
ID: 767027
Opened: 10/11/2012 4:00:00 AM
Access Restriction: Public
0
Workaround(s)
view

Description

CREATE COLUMNSTORE INDEX <IndexName>
ON <TableName> (<Column1>, <Column2>, <Column3>, ... <Column N)
ON <FilegroupName>
WHERE <Column1>= ''

A columnstore stores column1 on same pages, column2 on same pages,...
It would be helpful if these would be filtered.
Details
Sign in to post a comment.
Posted by Microsoft on 4/29/2013 at 2:33 PM
Hello,

Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing this bug is because the scenario reported in the bug are not common enough and due to the risk of implementing a fix it unfortunately does not meet the bar for the current version of the product.

If you have more supporting information and details or feel strongly that we should reconsider, please do resubmit this item for review.

To answer the second question: Yes, you can use a columnstore index on a partitioned table.

Thanks again for reporting the product issue and continued support in improving our product.
Gus Apostol, SQL Server Program Manager
Posted by Wim SQL Server on 10/11/2012 at 5:09 AM
Can we use a COLUMNSTORE INDEX on a partitioned table?
Sign in to post a workaround.