Тёмный

Microsoft SQL Server Index Architecture 

RunavaTech
Подписаться 552
Просмотров 84 тыс.
50% 1

Microsoft SQL Server Index Architecture. Simple yet powerful!

Опубликовано:

 

1 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 47   
@BRelding92
@BRelding92 9 лет назад
Very well explained, but I nearly fell asleep...
@shabashvalishaik6568
@shabashvalishaik6568 5 лет назад
after watching this video i got an idea how index works in background.......and best video in RU-vid i have ever seen........... thankyou so much sir
@paulcalinovici8808
@paulcalinovici8808 4 года назад
Why would you ever choose the values of the leafs to be keys to the clustered index over pointers to the heap?
@JP-td8gt
@JP-td8gt 6 лет назад
I have been trying to understand indexes for a while now. This video did a great visual explanation. Thank you.
@ancynoel5132
@ancynoel5132 6 лет назад
this is awesome !! Perfect one
@NONSPAN
@NONSPAN 6 лет назад
where did you get this from? is this part of a series?
@fieryscorpion
@fieryscorpion 4 года назад
This is the best explanation so far. Thanks a heap! 😉
@camelCase60
@camelCase60 2 года назад
9 years old and it still holds up 😊
@Prashanth-yj6qx
@Prashanth-yj6qx 3 года назад
Explain columnstore index
@khalidhusain2431
@khalidhusain2431 7 лет назад
Nicely explained . Thanks so much !
@Mtvjw
@Mtvjw 10 лет назад
Nice Video. Can you explain Multi Column Index in B Tree from?
@mohammedraziqali6400
@mohammedraziqali6400 3 года назад
Thanks for the video..
@siddharthsingh5829
@siddharthsingh5829 2 года назад
Thankyou 🙏😊🙏😊🙏
@siddharthsingh5829
@siddharthsingh5829 2 года назад
Thankyou 🙏😊🙏😊
@rickmemmer5625
@rickmemmer5625 3 года назад
The gold standard for this topic -- VERY NICELY DONE!! Thank you! :o)
@life_Excellent
@life_Excellent 3 года назад
Thanks.... excellently explained
@RavikiranS
@RavikiranS 5 лет назад
one of the best videos on indexes
@pawansripada
@pawansripada 2 года назад
WOW
@vinodpasi8021
@vinodpasi8021 10 лет назад
Nice explanation...
@affafa100
@affafa100 Месяц назад
Ausgezeichnet
@hugokornelis6840
@hugokornelis6840 6 лет назад
Ideal, thank you, i did not know many things about indexes, now I know
@murthymamidi6054
@murthymamidi6054 9 лет назад
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
@BRelding92 9 лет назад
murthy mamidi If you searched for just martin, you would get all the martins
@16thingskidscando8
@16thingskidscando8 8 лет назад
Excellent, thanks for putting in an actual example. Good job.
@mnatum-v17
@mnatum-v17 8 лет назад
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
@necbranduc 8 лет назад
He is comparing the actual values of "Rudd" and "Akthar", the text / string, not their corresponding pointer values (470501 and 470601).
@shobhanasurajkar9279
@shobhanasurajkar9279 4 года назад
Its checking alphabetical comparsion
@INvestYOU
@INvestYOU 10 лет назад
Well understood. Thanks
@DebayanKar7
@DebayanKar7 4 года назад
Golden explanation
@jubinsoni4694
@jubinsoni4694 4 года назад
Great explanation
@karthik23839
@karthik23839 3 года назад
great video,
@winstonchurchill3854
@winstonchurchill3854 7 лет назад
where i am can find full course?
@KareemMarey
@KareemMarey 9 лет назад
This is very helpful, thanks a lot.
@RajuSharma-po2rt
@RajuSharma-po2rt 7 лет назад
Very well explained..
@FresherstechkeysBlogspot
@FresherstechkeysBlogspot 10 лет назад
good
@thatcoding_teacher1258
@thatcoding_teacher1258 10 лет назад
iyhoooo! understood
@thehumanoid
@thehumanoid 9 лет назад
Good explanation
@shivaabhishek1915
@shivaabhishek1915 10 лет назад
Gud One...
@daveraffo
@daveraffo 11 лет назад
ok very good
@-ehabataa4093
@-ehabataa4093 10 лет назад
Perfect
@obulay213
@obulay213 7 лет назад
Data on the leaf level in the clustered key is stored sorted logically, not physically.
@user-dd5fs8uz5k
@user-dd5fs8uz5k 7 лет назад
correct
@saikiranp.r6966
@saikiranp.r6966 5 лет назад
It means it's also in sorted in ascending order ?
@fieryscorpion
@fieryscorpion 4 года назад
No, it's stored physically for Clustered Indexes
@fieryscorpion
@fieryscorpion 4 года назад
1:05
@buttofthejoke
@buttofthejoke 7 лет назад
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
Далее
I Took An iPhone 16 From A POSTER! 😱📱 #shorts
00:18
Bearwolf - GODZILLA Пародия Beatrise
00:33
Просмотров 359 тыс.
Dynamic Index Seek in SQL Server
11:15
Просмотров 827
SQL Indexes - Definition, Examples, and Tips
12:14
Просмотров 78 тыс.
Columnstore index in sql server (tutorial)
11:25
Просмотров 89 тыс.
How do SQL Indexes Work
12:12
Просмотров 622 тыс.
I Took An iPhone 16 From A POSTER! 😱📱 #shorts
00:18