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 https://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…