Columnstore Index in Azure Data Studio

It is used to store,retrieve,managing data by multiple column. it used on large Datawarehouse fact tables. It gains 10 times the query performance. It achieve 10 times the data compression.

Dept is the Table. Creating Columnstore index in all columns.

Query to Create Columnstore index

idx = index name.

1. Right click on Table ,Select Script as Create. 
 
CREATE NONCLUSTERED COLUMNSTORE INDEX [idx] ON [dbo].[DEPT]
(
    [DEPTNO],
    [DNAME],
    [LOC]
)WITH (DROP_EXISTING = OFF) ON [PRIMARY]
GO

You can Find above Query . There it describe idx (index) Created on Table.  Happy Coding .....

Post Author: adama