SQLTeam.com | Weblogs | Forums

Minimum size table for CCI (Clustered ColumnStore Idx) Recommendation?


#1

Hi,

Anyone know the lowest table row count a CCI needs to be before it has no benefits? Migrating DWH from TeraData to ss2014(Ent) ODS so 1000s of tables to CCI or regular indexing depending on various criteria's including row count/size.

Mixed info out there ranging from a million to tens of millions before a CCI becomes useful.

Thanks in advance