Tag Archives: sql server COLUMN STORE indexes

What is COLUMNSTORE Index in SQL Server?

What is COLUMNSTORE Index ? The SQL Server Denali (2011) launched a new type of index called the columnstore. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of times in some cases This can routinely give a tenfold speedup for a broad range [...]