KZhead

Clustered and nonclustered indexes in sql server Part 36

kudvenkat
2012 ж. 10 Қыр.
934 513 Рет қаралды
Жүктеу

In this video we will learn about
1. Different types of indexes in sql server
2. What are clustered indexes
3. What are NonClustered indexes
4. Difference between clustered and non clustered indexes
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our KZhead channel. Hope you can help.
/ @aarvikitchen5572
Text version of the video
csharp-video-tutorials.blogspo...
Slides
csharp-video-tutorials.blogspo...
All SQL Server Text Articles
csharp-video-tutorials.blogspo...
All SQL Server Slides
csharp-video-tutorials.blogspo...
All Dot Net and SQL Server Tutorials in English
kzhead.info...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic

Пікірлер

  • Man!... you have taught me so much and it's not just the quantity but the quality of your content is priceless!

    @jurianbraham3386@jurianbraham33864 жыл бұрын

  • Hi Venkat You are gifted and talented teacher. I think people who want to learn SQL they first open your videos.

    @kanyagudipati8605@kanyagudipati86058 жыл бұрын

  • Once again I have been saved by random indian guy on youtube. I am on my final interview at my dream job because of you. I really appreciate the help sir!

    @TopHatdudeman@TopHatdudeman2 жыл бұрын

  • You are the best!! This is the easiest way to learn SQL that I have found. You are very clear, concise, and give real examples on how to use SQL. Thanks so much.

    @georgewu5512@georgewu55128 жыл бұрын

  • Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

    @Csharp-video-tutorialsBlogspot@Csharp-video-tutorialsBlogspot10 жыл бұрын

    • Thank You! How do you highlight an entire line at once in sql server?

      @abdullahmohammad5613@abdullahmohammad56132 жыл бұрын

    • @@abdullahmohammad5613 ctrl+shift+End key

      @asharibahmad5267@asharibahmad526710 ай бұрын

  • Many links, videos, teachers explain these concepts in such a complicated way, maybe because they want to show off their knowledge or intelligence by making it complicated and then explaining it. But you Venkat have made it so simple to understand and Digest, that I love watching all these videos. I think this world is a better place because of people like you who make complicated stuff easy.

    @Salty_Matter@Salty_Matter4 жыл бұрын

  • I got tired searching through internet to find a simple explanation clustered and non clustered index. And my search ended with this video. Couldn't expect better. Kudos !

    @prateekrocks25@prateekrocks258 жыл бұрын

  • Brilliant explanation! I've read dozen of pages and still had question, but you explained everything in 15 minutes!

    @Mr__B.@Mr__B. Жыл бұрын

  • One of the best explanation about indexes. For non clusters index Christian song book, songs are ordered alphabetical order wher you can find the page number of the songs. Since songs are printed in topic order.

    @v2vlog622@v2vlog6223 жыл бұрын

  • Thanks.... Today first time I have been able to understand this topic... Properly.... Thanks a lot...u r a boon to students....

    @upwalebhaiya2477@upwalebhaiya24773 жыл бұрын

  • You are generating lights in each home and family of a software guy... Because of Your explanation which we are living life right now... Thankyou so much.. Expecting many more videos from you

    @srini3993@srini39933 жыл бұрын

  • sir i think there is a mistake in slide on time 15:57 ,there should be ..the NON clustered index has to refer back to the table as u explained on 15:05 to 15:35

    @pradyfunvlog@pradyfunvlog8 жыл бұрын

    • thats what i thought

      @asthatripathi9211@asthatripathi92116 жыл бұрын

    • I was about to mention the same. Thanks.

      @findmangesh@findmangesh4 жыл бұрын

    • I agree. It should be changed. I thought I was going mad...

      @LeonaMeyer@LeonaMeyer2 жыл бұрын

    • I did not catch the mistake, has that been fixed?

      @jag7450@jag74502 жыл бұрын

  • Yes, we can think it that way. Smart thinking. Thanks for taking time to leave your thoughts.

    @Csharp-video-tutorialsBlogspot@Csharp-video-tutorialsBlogspot10 жыл бұрын

  • This is the best explanation I've found so far for this subject. Thank you so much for all your tutorials, they've really help me a lot.

    @ChristianJensen-gu8ne@ChristianJensen-gu8ne Жыл бұрын

  • Thank you so much, your tutorial from 11 years ago still teaches me a lot!

    @wenyizhang3942@wenyizhang394212 күн бұрын

  • You managed to explain a subject that I really was struggling with. Thank you very much!!

    @walidkadhim1337@walidkadhim13379 жыл бұрын

  • That was so clear and easy to understand! I love seeing the examples of the actual sql code to create the clustered index table. Thanks so much :D

    @schnitzle@schnitzle9 жыл бұрын

  • My most favorite online tutor!!!!!!!!!!

    @hellofriend2012@hellofriend20129 жыл бұрын

  • Mr Venkat im very impressed, that you made this videos. Thank you a lot, you are great guy. Greetings from Poland.

    @martingrey738@martingrey7388 жыл бұрын

  • was ignoring this video, as it was long, but after watching many videos, and reading articles, i came here, and my search is finally over.

    @samit840@samit8407 ай бұрын

  • Dear Venkat, as usual, all your videos are very clear and to the point. THANK YOU so much for all your efforts to make this happen.

    @suchiravig@suchiravig8 жыл бұрын

  • Excellent explanation of the concept of how Indexes are used in SQL. Appreciate you sharing this video free for the entire community.

    @shreyajaiswal81@shreyajaiswal8111 жыл бұрын

  • Great explanation. I had a few issues with this topic so far, but your teaching has eliminated those doubts. The examples you consider are very easy to replicate and the way you describe is really awesome. Again a big thanks for the excellent work which you have undertaken.

    @anuragvashishtha6660@anuragvashishtha666011 жыл бұрын

  • Simply superb. I have been struggling to learn about this from long time & u made it clear with in 15 min.

    @manojpasumarthi@manojpasumarthi6 жыл бұрын

  • Great content. This and part 35 really helped a lot. Thank you!!

    @djb5255@djb52557 жыл бұрын

  • Explained in the best possible manner.

    @prakashsarraff3393@prakashsarraff33938 жыл бұрын

  • You explain stuff really well. Thanks for making me understand SQL.

    @knubbigfluffigkatt3972@knubbigfluffigkatt39725 жыл бұрын

  • your videos are awesome man. You're a great teacher, and that's coming from another fellow teacher who is trying hard to find good SQL materials that actually teach the content well. Your videos are just that. Great job sir!

    @those1kidds@those1kidds5 жыл бұрын

  • This is a superb video which helps the people who doesn't have any idea about indexs

    @rameshbevara3111@rameshbevara31119 жыл бұрын

  • Best Explanation on KZhead by far. Great Job!

    @perfectgaming788@perfectgaming7885 жыл бұрын

  • Thank you Kudvenkat sir...Awesome explanation...May God bless you..

    @64090sayan@64090sayan8 жыл бұрын

  • Thank you venka..for explaining in clear manner..

    @trinadhkadari1213@trinadhkadari12138 жыл бұрын

  • Love your way for clarification of the concepts..

    @HafizMazhar@HafizMazhar3 жыл бұрын

  • I always come back to your tutorials ...SQL, c#... Very easy to follow and good explanations by example. Thank you!

    @hrvooje@hrvooje5 жыл бұрын

  • Differences were explained well. I enjoyed watching this video. I recommend to watch this video by anybody. Thanks

    @krismaly@krismaly11 жыл бұрын

  • Hi Venkat, In the differences slide, in point 2, could you please correct the statement "clustered index has to refer back to table" to "non clustered index has to refer back to the table." Thank you!

    @priyankarora3461@priyankarora34617 жыл бұрын

    • Yes this statement is incorrect and is very misleading

      @LeonaMeyer@LeonaMeyer2 жыл бұрын

  • PERFECT! as always. Thank you!

    @johnny_rain3226@johnny_rain32264 жыл бұрын

  • Great videos. Thank you!!

    @bogdangirdea8929@bogdangirdea89299 жыл бұрын

  • it's the best tutorial for clustered index and non-clustered index I've ever seen. I can totally understand the definition through your lecture. thanks!!!

    @sevendong7830@sevendong78302 жыл бұрын

  • Thank you so much for this video ! It explains the concept very clearly. Thanks a lot !

    @breeze0n@breeze0n9 жыл бұрын

  • Im pretty sure that couldn't be explained better. Thank you so much :)

    @TraxxStudios@TraxxStudios8 жыл бұрын

  • Fantastic video my friend. I was struggling to understand this concept until I found your video. Well done! I owe you for creating this video.

    @tuelimishane@tuelimishane11 жыл бұрын

  • Very clear, to the point. Thanks Venkat.

    @di.vineapple@di.vineapple8 жыл бұрын

  • Really nice explanation for clustered and non clustered indexes. Thank you Venkat Sir!

    @sarikabiwalkar4037@sarikabiwalkar40376 жыл бұрын

  • especially you used a textbook as an example to explain the non-clustered index. really vivid and awesome!!!

    @sevendong7830@sevendong78302 жыл бұрын

  • I really appreciate such content! It is amazing, please keep it up and be the one of the most awesome guys in YT!

    @MahmutEKara@MahmutEKara7 жыл бұрын

  • Can't find better explanation than this. Simple and understandable. Thanks a lot :)

    @ganeshpoojary6753@ganeshpoojary67537 жыл бұрын

  • As usual, this topic was well explained. Not all smart people can teach. Thank you, Venkat.

    @arturoprepotente9837@arturoprepotente98372 жыл бұрын

  • Venkat thanks for the lecture. it's very lucid and to-the-point.

    @parijatbandyopadhyay8057@parijatbandyopadhyay80575 жыл бұрын

  • Your explanation of clustered and nonclustered indexes was a GREAT help.

    @phyllisthomas4464@phyllisthomas44647 жыл бұрын

  • you're my favorite online programming tutor, thank you very much and keep it up, you help a lot of people!

    @JATR1X@JATR1X10 жыл бұрын

  • Thanks a lot, for this nice explanation of Clustered Index and Non-Clustered Index.

    @uniqueperls@uniqueperls10 жыл бұрын

  • Hello Venkat, great tutorials ! and You are such a great teacher !

    @djjiang3718@djjiang37183 жыл бұрын

  • you clear the concepts of why and how both theory and in use case. This 7th video i watched on topic and finally understood the topic

    @arunkumaracharya9641@arunkumaracharya9641 Жыл бұрын

  • Venkat, Great explanation. Thank you

    @mayank12patel@mayank12patel5 жыл бұрын

  • Fantastic explanation, couldn't really get to grips with indexing before watching this video, thanks very much for posting

    @bernardwadding@bernardwadding7 жыл бұрын

  • Thank you for dedicating the time to educate on this topic. its a very detailed and clear.

    @ventorero28@ventorero2811 жыл бұрын

  • hi venkat ,thank u very much for ur time and clear explanation about the clustered and non clustered index i been learn a lot of thing from ur video thanks again

    @dergimorka6126@dergimorka61265 жыл бұрын

  • Thankyou so much Venkat for such a clear Explanation..

    @nehachauhan5716@nehachauhan57165 жыл бұрын

  • Now I finally undertand! Thank you Venkat

    @zoehyang@zoehyang4 жыл бұрын

  • Thankyou Venkat. we are so thankful for your videos

    @bhavyasinha6684@bhavyasinha66844 жыл бұрын

  • Excellent teaching sir!! Great ! my pranams to you

    @nimeshambalalpatel3032@nimeshambalalpatel30323 жыл бұрын

  • Hey man , i never thought any one can explain this in clear and easy way . Thank youuuuuuuu

    @alaasalameh8029@alaasalameh80293 жыл бұрын

  • Hi venkat, Thanku very much for this vedio,I have searched so many articals about non clusterd indexes but still not understood.But this day after watch u r video, I have been understood fully about indexes,and it would be helpfull to me to go furthure into sql.once again thanku very much

    @sivakumar-cs4ji@sivakumar-cs4ji10 жыл бұрын

  • Thank you for being such a great teacher :)

    @aerobicsparadise@aerobicsparadise11 жыл бұрын

  • This tutorial is very helpful i've tried studying this but didn't completely understand the difference between the indexes , your examples really helped me understand thanx!

    @user-cv9ef5wu1p@user-cv9ef5wu1p7 жыл бұрын

  • All videos are superb..👌. Thanks a lot Venkat.

    @TwinkleStar999@TwinkleStar9994 жыл бұрын

  • I enjoyed watching this video and I would suggest others to watch since topic has been clearly explained and also at the end there is an interview question was mentioned, which I experienced in my interview. Thanks a lot for educating the community.

    @krismaly@krismaly10 жыл бұрын

  • Now only I got perfect idea about indexes. Thank you so much

    @telugudevotionalspeeches8971@telugudevotionalspeeches8971 Жыл бұрын

  • 1. Yes, it is suggested to create a clustered index on a column that will be queries the most. 2. The column in the where clause should be included in the index. 3. SQL server uses unique index to enforce the primary key. So, if you already have a clustered index on a column other than the primary key, then a unique non-clustered index needs to be created on the primary key column to enforce the uniqueness.

    @Csharp-video-tutorialsBlogspot@Csharp-video-tutorialsBlogspot11 жыл бұрын

  • to the point and crisp explanation. Thanks. wish you covered examples for design patterns too in recent versions.

    @thiruvetti@thiruvetti5 жыл бұрын

  • Hi Venkat, very detailed explanation , it really helped me and cleared all my doubts. U r a gifted teacher.

    @deeptinirwal9672@deeptinirwal96723 жыл бұрын

  • very clear explaination..thnks alot

    @sonamawasthi7471@sonamawasthi74718 жыл бұрын

  • Clear Explanation. Thankyou so much!!!!

    @dhanaNehru@dhanaNehru7 жыл бұрын

  • This is great, thanks Venkat!

    @MrMotorboot@MrMotorboot3 жыл бұрын

  • You are telling the thing for which we are looking . Excellent 👍

    @decostarkumar2562@decostarkumar25622 жыл бұрын

  • Thank you for taking the time to explain this so clearly. Using your videos to support my SQL Server classes all the time!

    @futwi9362@futwi93624 жыл бұрын

    • Hello Rahiel - Thank you very much for the feedback. Means a lot. I have included all the SQL Server tutorial videos, slides and text articles in sequence on the following page. Hope you will find it useful. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ If you have time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.

      @Csharp-video-tutorialsBlogspot@Csharp-video-tutorialsBlogspot4 жыл бұрын

  • lucid, clear and to the point! Learning is fun. Thanx and Regds. Sudhanshu

    @sudhanshu7507@sudhanshu75078 жыл бұрын

  • Brilliant. Highly appreciate it!

    @jeetbarot7629@jeetbarot76292 жыл бұрын

  • Enjoyed your presentation...Gratitude.

    @TheUndeservedlove@TheUndeservedlove7 жыл бұрын

  • very good video helped me with my mcipt sql 2008 , thanks bro fro your community offering

    @tamilwargod@tamilwargod10 жыл бұрын

  • Hi Venkat, I am following all your video tutorials and inspired by them greatly. You are doing a great service. Keep doing the same. Could you please upload some practical examples of Design Patterns and UML? It wud be very helpful to everyone who's looking for it.

    @saranyarajagopalan262@saranyarajagopalan2627 жыл бұрын

  • Thank you so much. Helped me alot!

    @laba1987@laba198711 жыл бұрын

  • You explained well... thanks... finally I understood indexes 😊

    @pankaushik@pankaushik6 жыл бұрын

  • Brilliant explanation I have ever seen.

    @muhammadabuhuraira2407@muhammadabuhuraira24076 ай бұрын

  • Thank you very much sir for u r kind information.This information is very useful to me..

    @satyanarayana8320@satyanarayana83203 жыл бұрын

  • Revisiting Thanks for educating

    @krismaly6300@krismaly63008 жыл бұрын

  • As usual wonderful explanation Venkat Sir ! Just had one query ..can you please explain how can we decide which indexing should get used ?Is there any specific scenario ?

    @Nikita12957@Nikita129578 жыл бұрын

  • Good explanation of concepts with examples

    @stephendsouza2732@stephendsouza27328 күн бұрын

  • Love your accent. Content is also top-notch.

    @GauravSharma-rx7pl@GauravSharma-rx7pl3 жыл бұрын

  • thanks!!! this really helped

    @sameersane7192@sameersane71928 жыл бұрын

  • Clearly explained Indexes. Thanks

    @krismaly@krismaly9 жыл бұрын

  • great videos and explained in details, keep it up the good work as you are helping a lot people.

    @Kelmebrahtu@Kelmebrahtu3 жыл бұрын

  • Great explanation! Thank you!

    @pks7401@pks74012 жыл бұрын

  • Thanks a lot. Easy to follow.

    @sajeewamapa1663@sajeewamapa166311 жыл бұрын

  • Hi, there might be a typo in the slide that summarizes the "Difference" between Clusterred and NonClusterred. Non clustered index has to refer back to the data table if the column is not found in the index. In the slide, it reads that clustered index has to refer back... is that correct? Thanks.

    @zheng-guangwang5112@zheng-guangwang511210 жыл бұрын

    • Yes, you are right...

      @PravinKumar-qv9zd@PravinKumar-qv9zd7 жыл бұрын

  • This was REALLY excellent!

    @Nicky411@Nicky4113 жыл бұрын

  • your videos are very helpful .great work (Y)

    @aqsameer1764@aqsameer17647 жыл бұрын

  • Thanks..... from Peru.

    @jonathankun1@jonathankun110 жыл бұрын

  • What a noble man 👏🏻

    @AdmiringIntrovert@AdmiringIntrovert2 жыл бұрын
KZhead