Microsoft SQL Server Index Architecture

Microsoft SQL Server Index Architecture. Simple yet powerful!

[@shabashvalishaik6568]

after watching this video i got an idea how index works in background.......and best video in TH-cam i have ever seen........... thankyou so much sir

[@camelCase60]

9 years old and it still holds up
😊

[@JP-td8gt]

I have been trying to understand indexes for a while now. This video did a great visual explanation. Thank you.

[@rickmemmer5625]

The gold standard for this topic -- VERY NICELY DONE!! Thank you! :o)

[@16thingskidscando8]

Excellent, thanks for putting in an actual example. Good job.

[@fieryscorpion]

This is the best explanation so far. Thanks a heap! 😉

[@khalidhusain2431]

Nicely explained . Thanks so much !

[@RavikiranS]

one of the best videos on indexes

[@ancynoel5132]

this is awesome !! Perfect one

[@hugokornelis6840]

Ideal, thank you, i did not know many things about indexes, now I know

[@KareemMarey]

This is very helpful, thanks a lot.

[@mohammedraziqali6400]

Thanks for the video..

[@vinodpasi8021]

Nice explanation...

[@life_Excellent]

Thanks.... excellently explained

[@DebayanKar7]

Golden explanation

[@jubinsoni4694]

Great explanation

[@thehumanoid]

Good explanation

[@siddharthsingh5829]

Thankyou 🙏😊🙏😊

[@RajuSharma-po2rt]

Very well explained..

[@Mtvjw]

Nice Video. Can you explain Multi Column Index in B Tree from?

[@siddharthsingh5829]

Thankyou 🙏😊🙏😊🙏

[@NONSPAN]

where did you get this from? is this part of a series?

[@karthik23839]

great video,

[@BRelding92]

Very well explained, but I nearly fell asleep...

[@INvestYOU]

Well understood. Thanks

[@paulcalinovici8808]

Why would you ever choose the values of the leafs to be keys to the clustered index over pointers to the heap?

[@winstonchurchill3854]

where i am can find full course?

[@-ehabataa4093]

Perfect

[@shivaabhishek1915]

Gud One...

[@thatcoding_teacher1258]

iyhoooo! understood

[@daveraffo]

ok very good

[@nature_mm-v3w]

at 5:01 minute in the video ,Rudd>=Akthar= TRUE ? Rudd has 470501 and Akthar has 470601 ,So which one is greater ? am i missing something ???

[@necbranduc]

He is comparing the actual values of "Rudd" and "Akthar", the text / string, not their corresponding pointer values (470501 and 470601).

[@shobhanasurajkar9279]

Its checking alphabetical comparsion

[@murthymamidi6054]

If i Would like to search for a name called "Martin" ,because "Martin" is a duplicate VALUE ,so whether it give three rows data which contains name "martin" ?and also i have a question that i want data for martin ,how can i find that which martin i am searching for?

[@BRelding92]

murthy mamidi
If you searched for just martin, you would get all the martins

[@FresherstechkeysBlogspot]

good

[@Prashanth-yj6qx]

Explain columnstore index

[@pawansripada]

WOW

[@obulay213]

Data on the leaf level in the clustered key is stored sorted logically, not physically.

[@user-dd5fs8uz5k]

correct

[@saikiranp.r6966]

It means it's also in sorted in ascending order ?

[@fieryscorpion]

No, it's stored physically for Clustered Indexes

[@fieryscorpion]

1:05

[@buttofthejoke]

is this video sponsored by Microsoft? Like I get it, it is about SQL server. but for every step is it necessary to remind about SQL server? I mean I'm sure no one would think that one of the step in between is done by an Oracle server.. :p