Columnstore index in sql server (tutorial)

See our other Step by Step video series below :-

In this SQL Server tutorial we will try to understand columnstore indexes.

[tejaswil]

Thank you much sir.... very clearly explained. This helps a lot💗🤝God bless you

[abhay]

Very well explained sirji.😊 where is the Cluster index and non Cluster index videos i want to watch them 😊

[好好好-yb]

Thank you for the excellent explanation.

[amitthorat]

Thank you! Highly engaging and informative video.

[vikaspandey]

Really nice article and it helps me in clearing my doubts.

[jatindersingh]

Very well explained, Thanks for sharing

[sumantabasu]

Really good overview of the concept. However one question - even for an OLAP scenario, if the requirement is to retrieve all the columns of a table by a select query on basis of an ID field, does column store index on each field really provides any benefit ? or just non clustered index on that id field is sufficient?

[srinivasavula]

As a developer of ms sql server in my regular performance tuning I am creating indexes on queries having date columns as filters(ex retrieving the data created between 01-jan-2020 and 31-jan-2020), but sql server not recommended this column while creating the index...please explain...Thank you.

[amitbhattacharyya]

Can it support around 600 million rows 90 col table where i would do col index on about 60 col
? Any idea

[nikhilreddy]

If it is a Clustered Index, shouldn't the leaf node contain the actual entire row rather than pointing to the row? That is also the reason we can only have 1Clustered Index.

[ajaysharma]

Very much informative and helpful. Thank you for this.

[abraceyiii]

awesome explaination...keep up the good work

[tushibhaque]

Thanks fr this great tutorial...was waiting fr a video about columnstore index..

[irfankhanmohammed]

Great explanation Sir. I have a question. Is Nonclustered columnstore index is different to nonclustered index? Can you please answer this? I am bit confuse.

[mohanpara]

how compression works ? Will it merge duplicate values in a column as a single value ?

[srinivasavula]

Nice explanation sir..Column store index will increase the overall table size right...

[rekhakalyani]

Why am I not able to see clustered index in execution plan ? I have clustered and non clustered indexed on my table..when I click on execution plan I can't see the index just like your screen

[baskarlakshmi]

I have created columnstored index after that am faced error update statement failed because in a table that has a noncluster index. Consider disabling the volume tire index before issuing the update statement and then rebuilding the columstore index..Pls advice

[georgetuccio]

Another amazing video. You guys are awesome.

[sanjayschopra]

I need your help please let me know can we connect