As promised to provide little glimpse of each feature from the definition point of view, I am ready to deliver each feature each week for your kind notice.
- Column store Indexes:
A columnstore index is a technology for storing, retrieving and managing data by using a columnar data format, called a columnstore. A columnstore is data that is logically organized as a table with rows and columns, and physically stored in a column-wise data format.
For high performance and high compression rates, the columnstore index slices the table into groups of rows, called rowgroups, and then compresses each rowgroup in a column-wise manner.
They are the preferred data storage format for data warehousing and analytics workloads.
Use a clustered columnstore index to store fact tables and large dimension tables for data warehousing workloads. This improves query performance and data compression by up to 10x.
Use a nonclustered columnstore index to perform analysis in real-time on an OLTP workload.
How to create index through SSMS: