Columnstore Indexes Archives - Brent Ozar Unlimited®

Clustered Index key columns in Nonclustered Indexes

August 12, 2015Erik DarlingColumnstore Indexes, Indexing, SQL Server14 dba, development

clustered indexes are fundamental And I’m not just saying that because Kendra is my spiritual adviser! They are not ~a copy~ of the table, they are the table, ordered by the column(s) you choose as the key. It could be one. It could be a few. It could be a GUID! But that’s for another…

How to Add Nonclustered Indexes to Clustered Columnstore Indexes

March 25, 2014Brent OzarBad Idea Jeans, Columnstore Indexes, Indexing, SQL Server13 clustered columnstore, columnstore, sql 2014

SQL Server 2012 introduced nonclustered columnstore indexes, but I never saw them used in the wild simply because once created, they made the underlying table read-only. Not a lot of folks like read-only tables. (Bad news, by the way – that limitation hasn’t disappeared in 2014.) SQL Server 2014 brings clustered columnstore indexes, and they’re…

Category: Columnstore Indexes

Clustered Index key columns in Nonclustered Indexes

How to Add Nonclustered Indexes to Clustered Columnstore Indexes