Clustered Columnstore Indexes – part 29 (“Data Loading for Better Segment Elimination”)

Clustered Columnstore Indexes – part 29 (“Data Loading for Better Segment Elimination”)

Continuation from the previous 28 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ One of the key performance factors for Columnstore Indexes is Segment Elimination. I have been presenting on this matter for quite a while, but never actually blogged about it. Every Columnstore…

Clustered Columnstore Indexes – part 28 (“Update vs Delete + Insert”)

Clustered Columnstore Indexes – part 28 (“Update vs Delete + Insert”)

Continuation from the previous 27 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blog post is all about the architectural specifics & performance optimizations for the Clustered Columnstore Indexes. It is known that Inserts are mostly faster than pure Update operations, since we…