Clustered vs. Nonclustered Index Structures in SQL Server

Подписаться 14 тыс.

Просмотров 644 тыс.

50% 1

Clustered and nonclustered indexes share many of the same internal structures, but they're fundamentally different in nature. Watch Microsoft Certified IT Professional Jon Seigel explain the similarities and differences of clustered and nonclustered indexes, using a real-world example to show how these structures work to improve the performance of SQL queries.
Blog post on primary key vs. the clustered index:
voluntarydba.com/post/2012/10/...
CREATE INDEX statement reference:
technet.microsoft.com/en-us/li...
ALTER INDEX statement reference:
technet.microsoft.com/en-us/li...
Index navigation internals by example:
sqlblog.com/blogs/paul_white/a...
Sample index data is from the AdventureWorksLT2008R2 sample database:
awlt2008dbscript.codeplex.com/...
Visit my channel for more database administration videos:
/ voluntarydba
Subscribe to get notified about my latest videos:
ru-vid.com?...
Read additional content on my blog:
voluntarydba.com
Follow on Twitter:
/ voluntarydba
Like on Facebook:
/ voluntarydba

Наука

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

17 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 421

@nonam72 2 года назад

No nonsense talk or waste of time. Straight to the point with excellent presentation examples. Good Work. Thank you very much.

@abhiramm4941 Год назад

It is hard to believe that this video is from 8 years ago. Still the best video explaining the basics of both these indexes even in 2022.

@ColonelStraker 8 месяцев назад

Is it just me or did his eyebrows grow, during the course of this video and its edits?

@edwardsun4079 9 лет назад

Man, you fully rocked on demonstration the difference between Clustered Index and non-clustered Index ! This helps me on preparing for the interview questions !

@sharaf515 8 лет назад

Never before did Nicolas cage explain something so well, good job Nic. joking :D it was so helpful. thanks.

@VoluntaryDBA 8 лет назад

+Abd El-Rahman Ibn Omar lol

@diasneto5231 7 лет назад

kkkkkkkkkkkkkk

@doumkatekz 6 лет назад

And Nicolas Cage old has an odd sort of hottness. :)

@diananggriawanh8202 5 лет назад

HahhHahahah XD exactly

@learningearning8385 4 года назад

ha!!

@lorraineliu8422 5 лет назад

I've watched over 10 video. This is by far the most clear structured introduction to indexes! Thank you!

@michaelgebreselassie99 7 лет назад

I have been looking for different sources just to objectively understand the difference between clustered and non-clustered indexes and to know how they really work. This very short and precise video have put an end to all of my Qs. Thank you.

@Alstash Год назад

Elegant explanations like this are truly timeless, shifted through a bunch of videos attempting to word this same information in, like, double the time, and yet STILL failed to deliver as well as you did, sir, truly thank you.

@CorbinBohne 4 года назад

I always come back to this video when I need a refresher and it never fails to help me. Thanks again!

@falxonPSN 2 года назад

This is one of the best videos on this topic out there. Keeps it simple, but still clearly explains the structures and how it works. Very nice work, sir!

@vincewon8591 7 лет назад

Thank you so much for posting this! I was having a hard time understanding the differences between the two until i watched the video.

@jonobaker 6 лет назад

This video helped me ALOT, I've been watching many videos and this really clearly cleaned things up for me. The moving graphics were a big part of that too. thankyou!

@xphon12 3 года назад

Great explanation! This is the type of explanation that every developer can understand, no matter their programming level

@nkproductions742 4 года назад

Incredibly beautiful explanation of clustered and non-clustered indexes. There is a lot of material in those first 6 minutes, and I admit I had to pause several times to absorb it and move, but hey who is complaining when you get there eventually.

@ashish7459 9 лет назад

Really amazing, I was not aware that we can define type of index while applying primary key or unique constraints. thanks for amazing explanation :)

@radekou 9 лет назад

Wow, great explanation, love the usage of visualization of the data stored in structures. I've had an idea about how indexes work, but after watching this I'd be able to explain it to my grandmother (:

@TheGothicSecret 9 лет назад

Thank you for painting and diving deep in details of indexes!

@mike_yon 6 лет назад

This has been a great straightforward video that really helped explain the difference. Thank you keep up the good work!

@jacksrensen4475 2 года назад

Very good explanation ;) My tutors have tried to explain clustering and indexing for me multiple times, without my understanding. But your examples and explanation of the differences really helped

@kezhan01 8 лет назад

Wow, I could not image a man can explain it in such a simple way! Thank you!

@amaxamon 3 года назад

I know this has been up for 6 years but THANK YOU!!!!

@danm2756 8 лет назад

wow....best explanation. I'm studying for the mcsa exam. I've been struggling with this topic. thanks!!

@camelCased 8 лет назад

Thanks for the video, the phonebook example was good and easy to understand. From my experience, things sometimes get confusing because of different default behavior of different RDBMS - some automatically create clustered indexes for primary keys, some automatically create indexes on foreign keys, and some don't do any of this. So, sometimes you might get unpleasant surprises and performance issues if you have to deal with a RDBMS which you don't have experience with.

@MegaSmsm2011 10 лет назад

the best tutorial i have ever seen for MS SQL indexes, good job my friend

@VoluntaryDBA 10 лет назад

Thank you very much! I'm glad it helped you.

@NatashaSalam 8 лет назад

Great video, thank you for creating this and explaining the concepts in a concise and visual manner.

@ommi3756 9 лет назад

Never get this clear until this video. Nice!

@mikedaniels755 4 года назад

Perfectly concise and to the point. Well articulated and the visualizations help dramatically. Thank you very much for your contribution to the DATA world :)

@akashverma1640 Год назад

This is all I was looking for. Best explanation about behind the scenes of indexing.

@glebski1531 9 лет назад

really awesome explanation of a concept that I come across every day that has perplexed me to date... thank you sir !

@imrana.8370 4 месяца назад

I had a hard time understanding the difference until I watched your video. Thanks for the simple explanation!

@ckeveny1 10 лет назад

This is very useful. I now understand non-clustered indexes. Thank you

@Devilfairy1 6 лет назад

Best indexing explanation I've seen on internet.

@akankshakaul744 Год назад

Excellent video. Finally I could find a video which is so crisp and clear. Thanks a ton!!

@js34lee 6 лет назад

you have saved my life !!!!! genius explanation. I have been struggling to understand this for months after months

@srapdy6960 7 лет назад

Excellent explanation. I don't think this can be described any better. Great visuals. Thank you so much

@tommccann3559 9 лет назад

Bravo! That is most succinct explanation of clustered indexes I have ever read or seen. I've got it now :-)

@TheJimboNJ 6 лет назад

Thank you!! I particularly liked your examples and your methodical delivery of the information. I found the examples to be very helpful as well!

@ssaraswatipura 9 лет назад

Awesome presentation, looking forward to watching more of your presentation.

@serhankars 10 лет назад

One of the best tutorials I've ever seen. Thank you so much. Brief and infomative. Animations are very helpful also.

@VoluntaryDBA 10 лет назад

You're welcome!

@ladhkay 4 года назад

Most concise and easy to understand video out there. Thx man!

@RucuryBeans 6 лет назад

Very useful, thanks for making the video and explaining the concepts so well!

@tehawes0mesauce 8 лет назад

This video might save my advanced databases test grade tomorrow. I hate when the prof. doesn't explain stuff clearly enough for me. Thanks for the video - liked and subbed! :)

@Yousafkhan-gv7cs 9 лет назад

Very helpful especially the way you explain and display the concept.

@manasr3969 6 месяцев назад

Excellent video. Much easier with visuals than reading articles. Keep up the good work.

@AC-ft6mx 3 года назад

Never it was explained so well by others. Thank you !!!

@roidelalune01 9 лет назад

Very consistent video. I hope you will add more on this topic. thank you very much

@mallaiahsomula1714 4 года назад

Thank you so much, I never forget concept because of your visual representation. It made me to understand , very clearly

@Akshay-Raut 7 лет назад

its simple to understand with graphical representation. Keep up with them. Great work.

@hello-again6994 7 лет назад

great visual representation and model choice. subscribed!

@ArtemMikhaylov 7 лет назад

Perfect explanation I've ever seen before! Please do not stop!

@Major_Mason 5 лет назад

I am just starting to learn SQL. My dad is going to give me lessons, but this certainly helped me understand some of the terminology. I figured since I am already a Network Engineer who is two months away from his bachelor's degree, I want to make myself more valuable.

@TijiMathewrjj 7 лет назад

Very well illustrated and explained thoroughly. Well done.

@nareshnama343 6 лет назад

Thank you ...very help full and wonderful demo..we are expecting to see more demos off SQL server from you..

@condemned8916 7 лет назад

Sir 5/5 for this video , the visualization was a gr8 help in understanding . I had some knowledge that B-tree was the index data structure but could not grasp it , but after your video it helped me a lot. Plz do post more such videos.

@indric 10 лет назад

I understood more from this video than from a whole semester of lectures. Thanks!

@VoluntaryDBA 10 лет назад

You're very welcome! I'm glad it helped you understand these concepts.

@DownBeatTime 5 лет назад

The models you used were great! Thanks!

@pedropinto2192 5 лет назад

Very useful video! Your visual graphics made it very simple to understand. Thanks :)

@ezequiel_code 7 лет назад

it can't be better explained, excelent work

@Jemmeh 9 лет назад

Great video, very well put together and simplifies the topic well.

@KanagaveluSugumar 8 лет назад

Wow, Excellent content and animation. Thank you!!

@pradeepdesai9952 9 лет назад

Nicely put.. Specially graphical visual are the one which makes one understand much better .. .Thank you so much ...

@khaleda4873 3 года назад

You are so chill bro, thanks for the video.

@mehdizeynalov1062 Год назад

This man knows what he talks about - great. Waiting other videos.

@peeyar2000 9 лет назад

Great stuff about indexes.. Thanks for uploading.

@jaquesaulait 6 лет назад

Nice, clear delivery, good explanation. And he said "zed"! He speaks proper English..!

@caginbektas 5 лет назад

That was so helpful. Thank you for the clear explanation.

@viveksingh100k 7 лет назад

Explained in very short time .. Thanks very much :)

@troop53no Месяц назад

Thank you! I interact with a SQL database often, but indexes are not something I deal with enough. This was great information and exactly what I needed (:

@programmingbeasts4649 4 года назад

The best explanation of the indexes in SQL thank you so much

@kamalbalasubramanian621 5 лет назад

Best explanation with visuals. Kudos!!

@bobbysugianto5744 5 лет назад

what a brilliant explanation! subscribed! Looking further for your explanation about physical and logical operators in SQL Server and when is the best situation to use it (Nested loops, Hash Match, Merge Join, etc) Greetings from Indonesia!

@pablocazares4521 7 лет назад

very good! much better then others I've watched

@xiaoyi7538 3 года назад

Thank you so much ! You are amazing. Everything is explained so organized

@csmanul 9 лет назад

Thanks for explaining, i appreciate your effort.

@sathwicksv 4 года назад

Thank you very much, I have been reading at many places but no one explained with images. Greate video. Even MSDN documentation doesn't have this much information.

@gauravbabbar9808 6 лет назад

Best explanation i have seen for this topic. Thumbs up man.

@georgesmith9178 7 лет назад

I liked the visualizations best. The phrase "a picture is worth a thousand words" definitely applies to this video. Thanks for the concise and well delivered video. And, please, ignore the "Nicolas Cage" references below.

@user-ij2xw5qv6m 10 месяцев назад

Buena explicacion, estoy dando mis primeros pasos en SQL server, y tu explicación me aclaro muchas dudas

@INvestYOU 10 лет назад

Excellent demonstration.

@GhOnAu 8 месяцев назад

Great work, learned quite a lot about such a important topics in database the slides and visual explanation was piece of master piece

@AlphaWatt 5 лет назад

Excellent explanation. This truly helped.

@iainelder7607 10 лет назад

Thanks, Jon. I liked the visual example of the phone book - helped me to understand how indexes work without getting bogged down in bytes and pointers.

@VoluntaryDBA 10 лет назад

You're very welcome! That's exactly what I was going for.

@koalasy2011 6 лет назад

this is so good an explanation, I love you!!! good mate and good job.

@dineshsekar156 9 лет назад

Great Stuff. Nice Explanation. Thanks

@brendaolson5912 7 лет назад

Very good explanation of the subject.. Thank you

@tuanleanh6081 Год назад

Thank you so much for the super clear explaination!

@williamchin-fook8097 7 лет назад

Great Explanation and analogy about clustered-indexes 5 star!

@pjkumar5016 4 месяца назад

This is awesome, I referred lost video but this one really hits me. This is next level explanantion.

@RussianVideoPodcast 6 лет назад

I finally understood indexes...Very good video! Thank y ou

@tewodrosdebebe9062 5 лет назад

This is what i have been looking...Thanks!!!

@mohsenhs 7 лет назад

Awesome tutorial, Visualised and explained well, Fantastic, Many thanks

@vivaladida3130 4 года назад

very good job at explaining it, after so frustrated by my friend's explaination

@mvmassoudi 10 лет назад

Very Professional, clear and informative; I also loved the video animations. Thank you

@VoluntaryDBA 10 лет назад

You're welcome!

@HerdingDogRescuer 7 лет назад

Thanks for posting! I learned a lot!

@peterpanagopoulos9733 4 года назад

Brilliant explanation. Well done, thank you.

@naveenkumar7262 10 лет назад

Thanks for this nice video. It was short, simple and easy to understand. Thanks again!!

@VoluntaryDBA 10 лет назад

You're very welcome! Thanks for watching.

@dominicinzerillo7055 10 лет назад

Great stuff, made so much more sense then the books i have read.

@VoluntaryDBA 10 лет назад

All it takes is one "ah-ha!" moment, no matter where it comes from. :) Thanks for watching!

@nasarazam 9 лет назад

Precise and very well explained.

@reinersitanggang 7 лет назад

A lot wannabe blogs explained it with much much worse example, even a lot that even do not define from the scanning process through accumulate the results. Nice vid!