SQL Columnstore Index Explained | Columnstore vs Rowstore Indexes |

[@DataWithBaraa]

If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
TIMESTAMPS
---------------------------------
00:00 - Intro
00:23 - What is Columnstore Index?
01:45 - Process of Building Columnstore
08:15 - Columnstore vs. Rowstore Indexes
15:09 - How to Create Columnstore Index
19:54 - Columnstore Storage
Enjoy

[@gowthamiheroorsrikanth5018]

While I thought an Index was just an Index, you proved it wrong:) Omg! How do you make those complex things so easy Baraa? No matter how many times I tell you you are the best, it does not reach the level of appreciation I have for you in my heart.

[@Toyahan43]

Crystal clear explanation

[@yehiaEmad-f8f]

it can't get easier than that , thank you 💯

[@JayYoun-t1t]

I can't thanks enough for this super clean explanation, I'll recommend your Chanel to my colleagues,❤❤❤❤❤

[@Ansari_FX]

You are the BEST, BARAA❤❤

[@deepam.g4558]

BEST EVER. Thank you ❤🙇

[@udaymehta8917]

You put Big smile on my face by publishing the video...
Unexpected gift from hardworking person seating somewhere in the world.... 😇
I'm Grateful, Baraa sir.
Also, I want to know, when major SQL PROJECT will PUBLISHED?

[@arnab6476]

Thanks Baraa for the condensed lucid information.⌛

[@DivyYadav-hg2js]

Grateful for this seriessss♥️🙏

[@DataWithBaraa]

Thanks

[@juancruz7836]

Thank you Baraa! its always good news to have a notification from you uploading new material 👏😁

[@DataWithBaraa]

My pleasure 😊

[@ashutoshtomer1596]

Sir Your explanation is very clear and precise 🎉🎉😊😊

[@DataWithBaraa]

Thanks a lot 😊

[@rajshekar1362]

Thank you Baraa

[@vsahithi5937]

Thank you so much baraa

[@DataWithBaraa]

You're most welcome

[@DivyYadav-hg2js]

bara also can u cover one video on types of keys in sql its really confusing sometimess

[@DivyYadav-hg2js]

BARA in rowstore index the I/O efficiency should be lower right as compared to columstore index

[@DataWithBaraa]

Omg thanks !! Yes it is the way around like you said. 😅

[@govardhanreddy690]

Thank You Sir :)

[@DataWithBaraa]

Most welcome!🤗

[@plartoo]

I tried this by converting a 65M rows table (~10 GB in size) to clustered columnstore index. The table size shrunk for sure (to just 250 MB). BUT the query time did NOT improve (regardless of whether you are only SELECT-ing a subset of columns). In fact, the query time for `SELECT col_a, col_b FROM rowstore_index_table` is slightly faster than `SELECT col_a, col_b FROM columnstore_index_table`. I tried GROUP BY and the time taken to finish the query is pretty much the same between columstore and rowstore tables. Just wanted to share in case someone could point out what I'm missing.

[@DivyYadav-hg2js]

Bara i really wish u get pandas tutorial also one day im facing a lot of trouble learning it can u suggest me something???

[@DivyYadav-hg2js]

Thankk u baraa

[@godbhaigod]

Hey you said, Non Cluster keep both way, Row store and Column Store, But ChatGPT says this:
A non-clustered index doesn't store data in both row store and column store formats simultaneously. Instead, it can either use a row store or a column store, but not both at the same time within the same index
Edit: Got It, We have to use the Keyword Columnstore😅

[@DataWithBaraa]

👍👍

[@rajandayma]

Thanks, Baraa as always, we cannot download course material it is taking me to the MS server site. Please help

[@nitinrawat-g6t]

sir can you make sql project pls i am waiting and i watch your all videos thanks

[@DataWithBaraa]

I will add a project just have to finish few topics 👍

[@DivyYadav-hg2js]

Bara whats the next topiccc??

[@DataWithBaraa]

Few things about index, partitions, stored procedures then project