A SQL Server columnstore index is a column-based non-clustered index used to increase query performance for workloads that involve large amounts of data, like data warehouse fact tables. Learn more.