Columnstore Index: Differences between Clustered/Nonclustered Columnstore Index

(Sunil Agarwal) SQL Server 2016 provides two flavors of columnstore index; clustered (CCI) and nonclustered (NCCI) columnstore index. As shown in the simplified picture below, both indexes are organized as columns but NCCI is created on an existing rowstore table as shown on the right side in the pi

Read More - Register for Free Membership