CREATE "FILTERED" COLUMNSTORE INDEX - by Wim SQL Server

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


3
0
Sign in
to vote
ID 767027 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/11/2012 4:00:00 AM
Access Restriction Public

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