Episode 2: Row vs Column Store

[@laimeilin6708]

The concepts are clearly explained! Love the way you structure the content.

[@databasesdemystified7747]

Thank you!!

[@BC-hmm]

This is the best breakdown I've ever seen of this topic. Two thumbs up!

[@bobsmithson249]

This is the best video I’ve found to explain this. Thank you!

[@orrlevinger]

Should have much more views and likes!! best explanation ever

[@databasesdemystified7747]

Thank you so much! Definitely check out my other videos as well if you want to go deeper on other important database topics :)

[@zacharymandell7547]

Nice job. Excited for what's coming here!

[@rafaelmaranhao3710]

What an amazing video. It's both useful and straightforward

[@salomeqarchava9359]

It is really demystified. Easy to understand. Need more videos like this. Wish you'd have had more feedback and appreciation from the audience to continue making these videos.

[@akashjain7378]

Hands down the best video on this topic.

[@noahcoskun3989]

Great explanation of this concept, thank you!

[@bucketice300]

I am your 1000th Subscriber. Keep up the good work.

[@subashkunjupillai2489]

You were amazing with your crystal clear explanation! Kudos!

[@vikx02]

Great explanation tying the db internals to the benefits and drawbacks of row and columnar databases.

[@KitoKitko]

Thank You :) This is BEST crash course ever!

[@manikandanraju2405]

One of the best explanations I've come across. Thanks !

[@Enderman0000]

Jeez, what a great explanation. More so, in as little as 6 minutes!

[@chilelekohantuba3198]

simple yet detailed explanation. thank you

[@ADAMSIVES]

Excellent! Great explanation that's really helped me

[@techgrace7]

Thank you for such classic breakdown of this concept

[@sumanthachark]

Real good explanation!!

[@ClovisNeto]

Very nice video. Clearly explained, short and efficient! Loved it (y)

[@Tenshiwing]

Holy shit, what a great video. Been looking for this explanation for a long time

[@bawonos024]

Pretty briefed explanation. Need reference for Big Data, Data warehouse, etc. Thanks, man!

[@samyboulos4642]

Amazing presentation Thanks!

[@gokukanishka]

Very nice explanation, thanks

[@hemm2333]

One of the best explanations. Thanks 👍

[@hamzakazmi5150]

this is just amazing in such a short video how clearly you explained everything

[@denisvoronov6571]

Perfect video! Brilliant explanation!

[@abhishekparihar1]

very simple and clear way of explanation of ROW Vs Column Store index - please make more videos-

[@aybabtu]

Great explanation, thank you.

[@michaelkaminsky6942]

Thank you!

[@labib8aug]

best video ever on the topic

[@SEthan-wx6vt]

Thank you, that clearly explained what is the column store

[@praveen3123]

This video is Gold!

[@amirsoltaninezhad8161]

Very clear and excellent! Thanks!

[@oliverkuffner]

Great explanation! Thanks for this video!

[@SudhakarChintapalli]

Hi Michael, thank you for sharing your knowledge. Rather than solely providing theoretical explanations, it would have been helpful to delve into practical examples, such as querying different columns for a record in columnar databases. Given that data (columns) in columnar databases is scattered across various blocks, it's crucial to discuss the unique identifier in such scenarios.

[@balledachandrahas8326]

Excellent explanantion...!!

[@dsharma8198]

excellent explanation.

[@animeshsrivastava2398]

So easy to understand. Thanks

[@vinitsunita]

Very Good explaination. I have one question, How do you handle the row insert operation in case of Column oriented database as new data will need to inserted into each block.

[@michaelkaminsky9472]

Good question! This is non-trivial and why many data warehouses either don't allow or strongly discourage row-level inserts and updates (since you have to figure out where in each block to insert everything and move other things around).

[@michaelkaminsky9472]

Basically the answer is that "it's a PITA" for all of the reasons you can imagine.

[@ali194194]

Thank you sir .. Got the Answer. spot on...

[@briankimathi5033]

Fantastic💯💯

[@FedericoLov]

Good explanation but in practice it's very rare to query single columns so the benefits of columnstore are much smaller than expected. I work in a table with 100 million rows, moved from rowstore to columnstore and didn't notice that great improvement; on the contrary after enabling columnstore I still had to create quite a few non clustered indexes to cover my queries

[@databasesdemystified7747]

What sorts of queries were you comparing between the two systems? And yes, indexes definitely still matter!

[@xian5334]

Great explanation, thank you!

[@atousamas7232]

Great video

[@pavithranful]

Thanks for this, explained well

[@vdweghp]

Very good !!

[@marinaZrZ]

wow didnt know usyk was into data.. great video too!

[@TransparentWorld1275]

Will keep watching these vids, but I'm wondering if anyone has any book suggestions that has all of these concepts explained well and comprehensively.

[@prajwalpatil8500]

Thanks for this!

[@rAlarconBazan]

Store data by rows or. Store data by columns. Column storage is good for analytical workloads. Column storage is easy to compress.

[@puneetbanga6818]

Well explained

[@Sharmasurajlive]

Brilliant !!

[@phuinh9716]

greate video

[@gokukanishka]

Require your help in understanding In case Where there is a table with multiple records of a date And we write the below query : Example select name, id, date From table Where date =2017 In which row / columnar it will perform better If there was just one record of 2017 then it would definatly be row store But in case where there are more tha 1 row of the record which platform works better Note - there are multiple records of 2017

[@cherupawan3777]

Here row store index will be highly useful and generally u will be using Id as clustered index so now u can go with date as non clustered index so now all dates are arranged now u can access all rows with 2017 much easily. But when u take column store index data will be separated as columns so it would be take time to access all columns for a row by checking many blocks.

[@sumanthachark]

Nice

[@icarodlima]

🤯🤯🤯

[@nejimaiden]

Great explanation, thank you so much