Stores data in columns instead of storing in rows
Enables accessing data in easy and fast manner.
Improves processing time of Data Warehouse (DW) queries by hundreds to thousands times
To improve query performance, you need to build a column store index on the fact tables in a DW.
CREATE COLUMNSTORE INDEX [Index_Name] on [table_name] (Column_Name)