Clustered Columnstore Indexes

  • Dmitri Korotkevitch


It is impossible to modify data in tables with nonclustered columnstore indexes. This limitation is one of the major factors preventing their widespread adoption in SQL Server 2012. SQL Server 2014 addresses this problem by introducing updatable clustered columnstore indexes (CCI).


Data Warehouse Batch Size Execution Plan Fact Table Test Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Dmitri Korotkevitch 2014

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.FLUnited States

Personalised recommendations