Search

CREATE "FILTERED" COLUMNSTORE INDEX by Wim SQL Server

Active

2
0
Sign in
 to vote
Type: Suggestion
ID: 767027
Opened: 10/11/2012 4:00:00 AM
Access Restriction: Public
0
Workaround(s)
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 (expand)

Product Language

English

Category

SQL Engine

Proposed Solution

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

Primary Benefit

Improved Performance

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
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.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement