First published on MSDN on Jul 18, 2016
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 picture below while a table with CCI does not have a rowstore table. Both tables can have one or more btree nonclustered indexes.
Other than this, the physical structures on how data is stored in delta and compressed rowgroups are identical and both kinds of indexes have same performance optimizations including batchmode operators. However, there some key differences between these and the table below lists the main differences.
Thanks
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 picture below while a table with CCI does not have a rowstore table. Both tables can have one or more btree nonclustered indexes.
Other than this, the physical structures on how data is stored in delta and compressed rowgroups are identical and both kinds of indexes have same performance optimizations including batchmode operators. However, there some key differences between these and the table below lists the main differences.
Thanks
Sunil Agarwal
Updated Mar 23, 2019
Version 2.0Sunil_Agarwal
Microsoft
Joined March 06, 2019
SQL Server Blog
Follow this blog board to get notified when there's new activity