ColumnStore Indexes concepts and maintenance

What are Columnstore Indexes?

Understanding Columnstore Indexes in SQL Server Part 1

https://www.sqlpassion.at/archive/2017/01/30/columnstore-segment-elimination/

https://www.sqlpassion.at/archive/2016/03/21/clustered-columnstore-indexes-space-savings/

https://techcommunity.microsoft.com/t5/sql-server/columnstore-index-defragmentation-using-reorganize-command/ba-p/384653#

https://techcommunity.microsoft.com/t5/datacat/sql-2016-columnstore-row-group-merge-policy-and-index/ba-p/305255#

https://techcommunity.microsoft.com/t5/sql-server/adaptive-index-defrag/ba-p/383893

 

https://fonsecasergio.wordpress.com/2019/04/15/lesson-learned-1-columnstore-compressed-rowgroups-clustered-vs-nonclustered/

Rebuild Partitioned Clustered Columnstore Indexes

 

 

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s