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

[@PushkinMan]

One if not the best comprehension that I've gotten from a tutorial. Great examples, concise, straight-to-the-point explanation, and just beautiful editing. Big thank you, wish you luck and strength to continue to make such great videos.

[@DataWithBaraa]

Wow, thanks!

[@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.

[@rajeshrana6481]

LOTS OF LOVE AS ALWAYS BRO ..THANKS

[@sindhujareddy4659]

Omg! Great tutorial, really now a days I am learning a lot of concepts from your tutorial.

[@DataWithBaraa]

Awesome, thank you!

[@chrisk5269]

Thank you very much Baraa. You taught well: very good details with examples. I much better understand columnstore vs rowstore indexes. Great job!!

[@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,❤❤❤❤❤

[@Toyahan43]

Crystal clear explanation

[@juancruz7836]

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

[@DataWithBaraa]

My pleasure 😊

[@Ansari_FX]

You are the BEST, BARAA❤❤

[@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.⌛

[@ashutoshtomer1596]

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

[@DataWithBaraa]

Thanks a lot 😊

[@deepam.g4558]

BEST EVER. Thank you ❤🙇

[@DivyYadav-hg2js]

Grateful for this seriessss♥️🙏

[@DataWithBaraa]

Thanks

[@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.

[@vsahithi5937]

Thank you so much baraa

[@DataWithBaraa]

You're most welcome

[@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]

👍👍

[@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]

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

[@DivyYadav-hg2js]

Thankk u baraa

[@rajandayma]

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

[@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. 😅

[@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

[@rajshekar1362]

Thank you Baraa