Damn this really explained well for someone like me who doesn't want to dig into the technical details but more from the understanding perspective how these two are different :)
At 6:35 you give an analogy about a nonclustered index and a clustered index. If I understand what you are saying, are the following statements true: - A nonclustered index is like an index at the back of a book, with page numbers (each page number is like a row identifier) - A clustered Index is like an index at the back of a book, but no pages numbers (which would seem odd for a book to have)
Do you have a video that explains the differences between a table scan, index scan and an index seek and when SSMS will use each of these? If not, would you consider doing a video about this?
A very good video, only part is the example of the clustered index, in my opinion, should be a phone book or dictionary instead of textbook content as the clustered is physically sort/ordered the data, this example very much applied on the no-clustered index. Thanks.
Indexes should not be used 1)on small tables 2)tables that have large batch updates or insert operations 3)not be used on tables with high number of null values4)columns that are frequently manipulated
this video is really helpful . I have a doubt. If I have defined clustered and non clustered index and we are inserting new row, it will add the newly added row in specific position and shift other rows as per clusterd index. So, how non clustered index is getting benefitted here on inserting new rows. And is that possible to have table without any clustered index.
Ummm, regarding multiple nonclustered indexes. You made a comment that occasionally you have added a nonclustered index only to see other nonclustered indexes take a performance hit. If each nonclustered index is "independent", how could it effect the performance of other nonclustered indexes? When doing a query, doesn't SQL pick the most optimal index, and use that one? In other words, I suppose that it SQL "thought" a new nonclustered index was "faster" and used it, I suppose that would be possible, but wouldn't that we a problem with SQL?
Good video.it helped me a lot to understand clustered and non clustered index.can u plztell me that ..if i create unique key does it create a non clusterd index or clustred?
Nice video.. but my understanding was table of contents also like non clusterd indexes not the clusterd index. Because contents also have just the address of the details in that book. Please correct me if I am wrong. In the video @5.10 min this info mentioned..
Wow the mushroom book analogy wasn't enough? Just mentally picture a table of contents and an index for a book, failing that rewatch where he flashes those parts of the book :) I'd rather Bert spends time banging out quality info vids rather than labouring on pretty but unnecessary graphics
It's 2025 and I'm learning from this channel! Thank you!
Finally someone that explains by using realistic and relate-able scenarios...I actually get it now! Thanks
I went through all videos on RUclips regarding this topic and finally that's the one that makes it clear to me. Many thanks!
Dude, this video was 200x more effective than half of the Microsoft press 70-762 textbook. Thank you sooooo much!!
The mushroom book example is very helpful. Thank you!
Damn this really explained well for someone like me who doesn't want to dig into the technical details but more from the understanding perspective how these two are different :)
finally, a guy on point.. this was perfect!!
Man, you're my hero, I'm not a database guy but this was so perfectly understandable.
The better explanation ever found in the hole that are databases
Best explanation on index I have ever watched!
At 7:40, I finally understood the nonclustered index. Thanks.
Best video i came across so far, for this topic. Great analogies
Thanks man, I was searching for a good explanation of the differences between both, this was perfect!
Great Bert, very clear explanation on how to use the index.
THANKYOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! You made this so much easy
At 6:35 you give an analogy about a nonclustered index and a clustered index. If I understand what you are saying, are the following statements true:
- A nonclustered index is like an index at the back of a book, with page numbers (each page number is like a row identifier)
- A clustered Index is like an index at the back of a book, but no pages numbers (which would seem odd for a book to have)
Thanks! for explaining with practical examples
Do you have a video that explains the differences between a table scan, index scan and an index seek and when SSMS will use each of these? If not, would you consider doing a video about this?
A very good video, only part is the example of the clustered index, in my opinion, should be a phone book or dictionary instead of textbook content as the clustered is physically sort/ordered the data, this example very much applied on the no-clustered index. Thanks.
Indexes should not be used 1)on small tables 2)tables that have large batch updates or insert operations 3)not be used on tables with high number of null values4)columns that are frequently manipulated
Incredibly helpful on the difference between the two, thank you so much!
Thank you so much for this video! You explained the purpose of both types of indexes perfectly!
4:05 im confused why a insert would be so slow in this situation.
Can clustered indexas not be sorted by some sort of tree?
Thank you very much, would be good if some examples were added, maybe it's already there in next videos
FINALLY! An explanation I actually understand lol
4:55 easily explained
Thanks, blue eyes! That was helpful. Can you do a video on ColumnStore Indexes, please?
Absolutely brilliant explanation, thanks Bert!
Great work... solves my basic doubts
Thanks a lot Bert!
this video is really helpful . I have a doubt. If I have defined clustered and non clustered index and we are inserting new row, it will add the newly added row in specific position and shift other rows as per clusterd index. So, how non clustered index is getting benefitted here on inserting new rows. And is that possible to have table without any clustered index.
Great teacher. Very good to relate an analogy and explain.
Nice. Clear and succinct! Thanks!
This was really helpful. Thank you so much.
with the cheap cost of storage, is the extra space a unclustered index really that much of a downside?
This is so clear! thanks!
Really well explained, it helped me a lot!! Thanks!
Maan, this was spot on. Thank YOU
Ummm, regarding multiple nonclustered indexes. You made a comment that occasionally you have added a nonclustered index only to see other nonclustered indexes take a performance hit.
If each nonclustered index is "independent", how could it effect the performance of other nonclustered indexes?
When doing a query, doesn't SQL pick the most optimal index, and use that one?
In other words, I suppose that it SQL "thought" a new nonclustered index was "faster" and used it, I suppose that would be possible, but wouldn't that we a problem with SQL?
So for a report that runs from a SP with a couple of temp tables. Is it better to add cluster index after filling the tables?
Great review, thanks!
Good video.it helped me a lot to understand clustered and non clustered index.can u plztell me that ..if i create unique key does it create a non clusterd index or clustred?
Nice video.. but my understanding was table of contents also like non clusterd indexes not the clusterd index. Because contents also have just the address of the details in that book. Please correct me if I am wrong. In the video @5.10 min this info mentioned..
Getting access denied when trying to view the blog with examples
fantastically explained!
Hi bro if you could have explained in practical way it would have been better for all of viewers.
Great Explanation
Thank you!
Nice explanation..! create more videos on others indexes
well said! great video
Thank you, thank you, thank you
Very helpful, thanks.
@@DataWithBert Yea man, I just cut a 20+ min query down to 6 seconds by creating a proper non-clustered index! Wow!
Thank you
SCREAMING AT THE INTRODUCTION
Outstanding!!!!
thank u
You remind me of the protagonist of Inception
Hi please next time please please use some animation or drawing...
That will help a lot...
Wow the mushroom book analogy wasn't enough? Just mentally picture a table of contents and an index for a book, failing that rewatch where he flashes those parts of the book :) I'd rather Bert spends time banging out quality info vids rather than labouring on pretty but unnecessary graphics
@@richardplester Hi, at least you can draw on board, C its for better understanding for me..
Hai sir,Pls provide me with demonstratation of clustered and non clustered index with small examples...
Thank you sir
Very helpful, Thank you
Super Helpful, Thanks