What are Clustered Indexes vs. Non-Clustered in SQL Server 2008 R2 Software Tutorial
2011 ж. 30 Қаз.
78 206 Рет қаралды
What are clustered indexes? How are they created? What is the connection between the primary key and the clustered index? How do I optimize the performance of SQL Server 2008 tables by using indexes?
Try our free sales and customer reporting web service at www.reportingsales.com
your 11 years old video is worth it for me today because it helps me to understand concept of clustered data because my final term is coming and dbms subject is also there. thanx to explain in a simple way
THANK YOU! THANK YOU THANK YOU THANK YOU SO MUCH Dear god why don't people use real and simple examples to explain something… God bless you sir.
Besides feeling like if I'm getting screamed at by an older sibling or parental figure, I still learned exactly what was described on this video. Very informative. Thank you!
Great video, I am starting my career as a DBA. And came across the chapters for indexing, and these videos are helping me understand all the theory. Thanks.
Thanks for the feedback! Most RDBMS products use some form of the B-Tree index like SQL server. SQL and Oracle are good examples of products that use row-based storage and indexing. However, there are many columnar based databases out there now (e.g. Sybase IQ, Vertica) which do use a different architecture and store data by column instead of by row. These are optimized for fast queries which don't need access to an entire row at a time.
your 11 years old video is worth it for me today because it helps me to understand concept of clustered data because my final term is coming and dbms subject is also there. thanx to explain in a simple way
Excellent tutorial: clear, succinct and professional. Thank you.
Excellent, now i can add this to my training schedule!
Nice video, but introduction of Non Clustered Index is missing
Can't believe I had this so wrong for so long and that NONE of the other videos or hundreds of pages of learning material even mentioned the fact the index IS THE TABLE ITSELF
clear and easy to follow, well done.
Thank you very much sir great tutorial very practical I got to know what actually Indexes are
Good video and I liked it. Do you have a blog where I can see all your presentations? If you never mind if I ask you what recording software you used in creating this video?Thanks a bunch.
Thank you for that great feedback!!
Finally understand clustered index!
Well done! Super clear. Thank you!
Well Presented! Thanks!
Very clear... really helpfull
Nice explanation
brilliant and very informative video. Very helpfull
Very good video about clustered index.. was there information about non-clustered that I miss.. or was it supposed to be obvious?
Is there any noticeable difference of how indexes are used on different platforms? Great tutorial btw!
Great video
Thank for your HelpFUll Video
OMG. THANK YOU.
its very useful thanks...........
Thank you so much
this is good one..
even though ur voice is a bit scary mate but it was a great help thanks alot mate ta
THANXXXX :)
no explanation of non-clustered or any of its differences to clustered so its a misleading title
grt say
if i had British accent i would never stop talking and i'll explain the whole Oracle organization :-)
Wait, is this some advanced text to speech voice talking?
Is it me, or does this guy talk like Christopher Walken :) ?
Besides feeling like if I'm getting screamed at by an older sibling or parental figure, I still learned exactly what was described on this video. Very informative. Thank you!
Is it me, or does this guy talk like Christopher Walken :) ?