At what size should we consider applying Columnstore Index on a table? Is there a SQL Server storage or design guidance?
Our Data Warehouse is 5TB total. Additionally, we have tables which are 100GB to 1TB which compose the database. Just curious if SQL Server has guidance on how large should table before a columnstore index is applied?
For Fact Tables: Eg, should we have columnstore index on table that is 300MB, 1GB, 1TB. Or should we have on all tables, and size does not matter?
For Dimension Tables: Additionally, should we have columnstore indexes on lookup tables? These are small, generally 2-50 MB
This article never stated