Dec 17, 2019
Columnstore Index In SQL Server
COLUMNSTORE INDEX:
- Columnstore index It is mainly used for improving query performance with a large amount of data it uses when selecting the record.
- Columnstore index used in the OLAP system. This type of index stored index data in the column-based format.
- Columnstore index uses because of the high level of compression and better performance.
- In Columnstore Index, the scanning column store index entirely or only a range.
I have created a table In this table three-column which is the Product, Code, and ID. And on ID apply primary key and clustered index.
CLUSTERED INDEX: In Clustered Index, scanning a clustered index entirely or only a range.
- Estimated I/O Cost of Clustered Index is 0.0083102.
Create a Columnstore Index:
Goto the table design right clicks on a column and select indexes/keys. Here show that the MyColumnStore index is created.
When we use columnstore indexes Estimated I/O Cost decreases and the better performance of a select query.
- Estimated I/O Cost of Columnstore Index is 0.003125.
If we can write a basic aggregation query then that the entire query was satisfied by scanning the column store index. No table access was even required.
If you are a newbie to database learning — SQL Server recommended is the following must-watch video: -
