Creating a columnstore index for a dimension or fact table

A columnstore index is a type of compressed nonclustered index and is used to speed up queries against large tables. It is a technology for storing, retrieving, and managing data by using a columnar data format, called a columnstore. Only one columnstore index can be created per table. A table with a columnstore index cannot be updated. For all table update related tasks, DWD drops the columnstore indexes, updates the table, then recreates the columnstore index.