How do SQL Indexes Work

Thanks for this informative series . When can we expect the detailed series on Execution Plan ? Please upload it asap !! No words Simply You are awesome ❤❤❤

your great! perfect tutorial. keep going

Thanks. It's very usefull.

this is a great video.

Very nice explanation!!

Extraordinary explanation, really really helpful

This was a fantastic explanation!

Always learn something new when watching your videos!

your videos are teaching me more than uni

thank you

Creating indexes will save time but cost more disk space if I understand it correctly?

Superb and elegant explanation

what is the unit of measurement for the Estimated Subtree cost?

Helpful!

How can u explain how indexing works on composite index containing more than 2 columns

Neat explanation to the point! Thank you :)

Many, many thanks!

the example you showed by adding 1M data and retrieving one record blowed my mind. I was always thinking like how to test query optimization theories, it needs a large amount of data. This is the way. Thank you very much

very well explained!

Thank you for those lessons about indexes - the explanations are just great! Can you please consider recording videos about covered and filtered indexes in MS SQL Server as well? Would be very grateful!

Till now bestest best in sql index 🎉😊

please explain how other index works (not only btree but also gin)

Fantastic videos, subscribed!

I watched many other videos, those were either not useful or not covering the details to the fullest. Yo have exceeded my expectations. Thank you very much. Keep up the good work.

fantastic video tutorial

so should put index on all column?

Thank you, that was helpful to understand how indexes work!

thank a ton

dont you mean columns? Why Rows?

You explanation❤️

thanks

Thanks! I've worked with MySQL for years but didn't know the Execution Plan.

Hi,

The second case where the record that belongs to a particular name is fetched then the physical and logical operation performed is
called Clustered Index Scan even though name does not have clustered index. Why are the physical and logical operation not called table scan
when we know that the SQL scans each row to fetch the row where the name is = "ABC 932000"

I found gold in this page. thank you brother.

Is it possible to use non-clustered index without having a clustered index?

Nice refresher video. Thanks!

Nicely explained

Venkat this is just amazing. Thanks a ton!

Mind if I ask a question? What if the name (non-clustered index) is not sorted in alphabetical order at the start? Does the database engine take another step to sort them before creating key value - row locator?

just love your videos thankyou

The man the legend the myth

awesome bro..

Thank you Kudvent! The explanation is crystal clear! I like how you speak slowly and it makes easier to follow the mass media content now is too fast to catch people's eyes and make the majority into a stressed mode.

T

U have a great voice and explanation 💯

Wow, you are incredibly smart and give the PERFECT explanation!
Thank you very much!!