KZhead

Indexes in sql server Part 35

kudvenkat
2024 ж. 21 Мам.
820 298 Рет қаралды
Жүктеу

In this video we will learn about
What are indexes
Why do we use indexes
Advantages of indexes
These concepts are applicable to sql server 2000, 2005 and 2008
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

Пікірлер

  • Respect to this guy. I'm employable because of his tutorials

    @solifaspearsesalimu4865@solifaspearsesalimu48656 жыл бұрын

    • Same xd

      @MarianoGianni1@MarianoGianni15 жыл бұрын

    • 🙋🏽‍♂️ same

      @aaronaaronaaron5922@aaronaaronaaron59224 жыл бұрын

    • same,,,,

      @harshpatel-wr1jl@harshpatel-wr1jl4 жыл бұрын

    • Me too

      @Anask_M@Anask_M4 жыл бұрын

    • Hii

      @chetnasrivastav2691@chetnasrivastav26913 жыл бұрын

  • Can we send Venkat a recognition award or something? I have never fallen in love with SQL, this guy makes it so simple to understand.

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

    • why not

      @KumarAnalytic@KumarAnalytic2 жыл бұрын

  • Dear venkat, I went through your all the sql tutorial vedios. you are the best online teacher..I just want to thank you for your time and efforts for these vedios.

    @kalingasarangi3584@kalingasarangi35847 жыл бұрын

  • Only Thanks is not enough for you. You deserve a lot. I have been watching videos from 1 to 35 for this course. You are just awesome. God bless you man.

    @inayathussaintoorie@inayathussaintoorie10 жыл бұрын

    • Why are you watching just 1 to 35?

      @amruthavarshinichaganti5667@amruthavarshinichaganti56672 жыл бұрын

    • @@amruthavarshinichaganti5667 he commented at the video he has reached for now ( this video -> Part 35

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

  • My very first source of learning sql was this channel, learner a lot

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

  • Kudvenkat, you are the best!!!!!!!!! KZhead needs to seriously pay you for such a talent!

    @PS-vc6ef@PS-vc6ef2 жыл бұрын

  • You are the best man. Keep your education mission ;-) Best Regards ;-)

    @nasgaroth1@nasgaroth19 жыл бұрын

  • The best explanation of indexes till now! Thank you so much for this.

    @sapnaantara9031@sapnaantara90312 жыл бұрын

  • You are my hero! Each time I need to check up on some relevant topics, I can find them on your channel.

    @stillborn007@stillborn00710 жыл бұрын

  • Thank you so much for helping out the people for free. #RespectYouSir

    @Saadsafeer0@Saadsafeer07 жыл бұрын

  • Kudvenkat you are awesome. Thank for all your uploads!!!

    @captfish93@captfish9310 жыл бұрын

  • "We will talk about it in the next session". I go fast to the next session! Thanx Venkat!

    @krzysztofs8535@krzysztofs85357 жыл бұрын

  • Rewatched. Thanks a lot for educating community

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

  • Very well done, Venkat! Thank you for your tutorials!

    @camsebe@camsebe10 жыл бұрын

  • You are very welcome. 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 жыл бұрын

    • Dear Sir Venkat, u r the best ,urs most honest teaching from basics to high industry level is 0n the TOP among the tutors, mentors eduactors available worldwide & on utubes for c# asp, sql server mvc ..and many more..I wish to see ur face .but cud only hear ur voice...wish u happy healthy long life..u hv done a great work for mankind..in IT ..whether a student is poor or rich ...everyone can get in depth true knowledge from u ..SALUTE u sir

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

  • A good start towards working with Indexes. Eager to learn more on Index, so starting with the next video of the series. Thank you!

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

  • Excellent work sir .I am able to work as DBA just bcoz of you . hat's off to you..

    @tourmaniathought3080@tourmaniathought30802 жыл бұрын

  • Revisited to refresh my memory. Thanks a bunch

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

  • perfect Videos for beginners. Thanks Venkat..

    @INvestYOU@INvestYOU9 жыл бұрын

  • Thank you for create every student to Understand practical with example so a effect for all tutorial. Thank you brother.

    @darshanwala5561@darshanwala55613 жыл бұрын

  • This was the best explanation I have heard, thanks Kudvenkat....you are the best.

    @danielhunter9301@danielhunter93015 жыл бұрын

  • I just gone through bcos i was asked about the indexes in interview today.... and found this very useful... thanks for sharing

    @nik08101986@nik081019867 жыл бұрын

  • You're a brilliant teacher. I greatly appreciate your tutorials🙌

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

  • Thank you Venkat for the wonderful gift of Knowledge. Good bless you

    @Shubhamkumar-ir5ox@Shubhamkumar-ir5ox Жыл бұрын

  • Excellent explanation, easy to understand. Thank you!

    @pogococo2246@pogococo22466 жыл бұрын

  • Clear and detailed presentation. Thank you !

    @dimitrix2010@dimitrix201011 жыл бұрын

  • the best explanation and videos i have never watched before. thanks a lot sir!

    @Fcb447@Fcb4477 жыл бұрын

  • You are the best man. Keep your education mission

    @williamwang2047@williamwang20476 жыл бұрын

  • Very good video for a beginner. Thank you

    @richardpalawofski3031@richardpalawofski30319 жыл бұрын

  • nice explanation ....thank you

    @asmaasedeek3464@asmaasedeek346410 жыл бұрын

  • thankyou so much sir.. great explanation....:)

    @ankitsharma-tr3be@ankitsharma-tr3be8 жыл бұрын

  • You are the best online teacher. Kudos brother

    @rakeshgowda8520@rakeshgowda85206 жыл бұрын

  • thank you so much you have made the description so much easier to understand

    @CH14life@CH14life11 жыл бұрын

  • i like ur teaching style (great teacher ),love from pakistan.

    @sufyanalishani5038@sufyanalishani50386 жыл бұрын

  • Great tutorial! Thank you very much!!

    @JohnWaclawski@JohnWaclawski11 жыл бұрын

  • thank you for these tutorials

    @qualityrenov@qualityrenov8 жыл бұрын

  • hi , i really like your all tutorials ,thank you so much to be teach me ,you r the best teacher

    @dodukashyap5971@dodukashyap59716 жыл бұрын

  • Perfect explanation. Many thanks.

    @wasE3m1@wasE3m16 жыл бұрын

  • Venkat your communication us wonderfull..nice explanation

    @harthikgroup7156@harthikgroup71563 жыл бұрын

  • Thanks for sharing. These videos are very helpful

    @umasakshi4966@umasakshi49667 жыл бұрын

  • Kudvenkat, you did a great job on this video. Your English is also very good.

    @cecilchampenois7112@cecilchampenois71124 жыл бұрын

  • This is one of the few times I pause the adblock. Keep up the good work. If we can support you and your work in some way, let us know

    @mohanadhmd@mohanadhmd5 жыл бұрын

  • Awesome explanation .Clearly understood

    @rohinisahajayogini8361@rohinisahajayogini83612 жыл бұрын

  • Really appreciate your contributions :D

    @magdagabrielayanezmarin4449@magdagabrielayanezmarin4449Ай бұрын

  • hi dude, i've learnt a lot from u Greetings from mexico

    @videos4homies938@videos4homies9385 жыл бұрын

  • Very clear and sumple explanation, thanks.

    @saurabh75prakash@saurabh75prakash5 жыл бұрын

  • Thank you for doing this extremely helpful

    @Shovaan1408@Shovaan14086 жыл бұрын

  • Sir .. Thank you very much......... For your valuable videos

    @saikiranguntuku171@saikiranguntuku1716 жыл бұрын

  • Great video. Thank You.

    @krzysztofs.8906@krzysztofs.89066 жыл бұрын

  • Thanks for the video, great explanation!

    @ynufri@ynufri8 жыл бұрын

    • Kiril Anastasov 5 6o6

      @NarinderSingh-qe9pe@NarinderSingh-qe9pe6 жыл бұрын

  • thank you very much sir☺ video was very helpful

    @gomathil4610@gomathil46106 жыл бұрын

  • you are amazing thank you for all the videos

    @ASX373@ASX3733 жыл бұрын

  • I am brazilian and not advanced in English, but I like your videos and the subtitles helps a lot. Thank you.

    @fernandosanches7111@fernandosanches71117 жыл бұрын

  • sir you are great

    @user-ho9ge6xh7u@user-ho9ge6xh7u2 ай бұрын

  • very nice sir , thankyou for this

    @varunjain4571@varunjain45719 жыл бұрын

  • Best tutorial in KZhead..

    @yuvaraniganesh3140@yuvaraniganesh31405 жыл бұрын

  • Wowwwwwwwwww, thats it, my select query run 50x faster. Sir well done and I appreciate it.

    @impossiblehousemarylandsta6266@impossiblehousemarylandsta62665 жыл бұрын

    • Hi Kerem - Thank you for letting us know. Great news. Indexes are great from a performance standpoint when reading data.

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

  • Really sweat teaching !!!!

    @videocoll1@videocoll110 жыл бұрын

  • great video! thank you

    @biancadragomir@biancadragomir6 жыл бұрын

  • awesome explanation :)

    @MrTechGeek01@MrTechGeek0110 жыл бұрын

  • Great video !!

    @jayashreereddy5643@jayashreereddy56438 жыл бұрын

  • very very nice.

    @kaushikbhadani@kaushikbhadani10 жыл бұрын

  • This is old, but this is the best course you can find online!

    @TrungNguyen-ld7hz@TrungNguyen-ld7hz3 жыл бұрын

  • Concept explained clearly. When user goes to create index in designer menue are changed from Server versions. I think you may be using 2005 or 2008. I am using SQLEXPRESS2012 and it directly defaults the index to Non-Clustered if there are no indexes'. Also if you could mention what would be default for ASC or DES for a column. Pl note I am suggesting not criticizing. I love your videos. I enjoyed this video. Thanks a bunch

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

  • very clear video. thanks very much.

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

  • thanks alot.. its pretty helpful

    @gunveetsinghchhabra3272@gunveetsinghchhabra327211 жыл бұрын

  • Thankyou very much sir.it's really understandable

    @surekhavani3859@surekhavani385911 жыл бұрын

  • Perfect! one things i want to know when to use tempdb in development.

    @ramkr88@ramkr888 жыл бұрын

  • Thanks for all your help! Best SQL Tutor... Was wondering if you have classes on BIG DATA or JAVA

    @oloruntobaonabiyi6199@oloruntobaonabiyi619910 жыл бұрын

  • Very nice learning experience

    @tusharkaushik79@tusharkaushik792 жыл бұрын

  • Thank you so much

    @dauculajava@dauculajava9 жыл бұрын

  • Thanks it helped!

    @poojarj055@poojarj0552 жыл бұрын

  • nice video sir its very helpful for us

    @md.aarifansari1957@md.aarifansari195710 жыл бұрын

  • Thanks for the Video ...

    @SendilP1@SendilP111 жыл бұрын

  • very good tutorial. thanx

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

  • isko bolte h 1 no video tutorial.

    @ushmailoveu@ushmailoveu11 жыл бұрын

  • you are amazing!!

    @TheShahanasiddiqui@TheShahanasiddiqui4 жыл бұрын

  • Thanks for your information. solve lot of loading problem

    @kayaliqbal@kayaliqbal7 жыл бұрын

  • Man I LOVE YOU.. NO homo..you are a great tutor.

    @pouremilee@pouremilee8 жыл бұрын

  • Pretty good video! even nowdays, pretty easy to understand! Only downside is that there is no examples with an without what the performance is and the gain. Though that is not the goal of the video.

    @_JustBeingCasual@_JustBeingCasual5 жыл бұрын

  • watching in 2023 ... wondering how you created such awesome content 11 years ago !!👏

    @Blackhole-0@Blackhole-05 ай бұрын

  • Very useful video thank you

    @nakulanand2725@nakulanand27252 жыл бұрын

  • Hello Venkat thanks for such a great videos. I have a query.... I am learning Oracle database... can I follow the same videos what you have uploaded on Indexes, stored procedures?? are they same for both Oracle and PL SQL ?

    @URG_Creations@URG_Creations7 жыл бұрын

  • Best tutorial ever

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

  • Thank you very much.

    @kinhho1128@kinhho11285 ай бұрын

  • i read tens of documents but still couldn't grasp the topic,, watched your video, and boom!!

    @adityatomar6231@adityatomar62312 жыл бұрын

  • thank you very much sir

    @shriramgarje2229@shriramgarje22298 жыл бұрын

  • thank you for these videos. i have a general knowledge in computing. do you provide tutorials lessons for those who want to be SQL certified?

    @musiwalter3214@musiwalter32146 жыл бұрын

  • thank you very much

    @ShayMor_Marketing@ShayMor_Marketing10 жыл бұрын

  • You should have mentioned about the binary search that takes place on the separate table that is created with sorted key values

    @gaureesha9840@gaureesha98408 жыл бұрын

    • Its a B-TREE not a BST

      @shubhankarpaul2740@shubhankarpaul27402 жыл бұрын

  • Best teacher

    @moinmukhtar5084@moinmukhtar50842 жыл бұрын

  • very nice tutorial

    @anandsilwal5001@anandsilwal500110 жыл бұрын

  • Thanks

    @learnwithme1201@learnwithme12019 жыл бұрын

  • Nice video.

    @arjunlama1080@arjunlama10804 жыл бұрын

  • Thank you.

    @BijouBakson@BijouBakson4 жыл бұрын

  • Ur god in sql field####

    @aksingh175@aksingh1753 жыл бұрын

  • Thank you for the video. I have a question if you can answer please. When we run sp_Helpindex table_name, it would display indexes on that table plus unique/primary keys defined. Am I correct?

    @sudhee67@sudhee6711 жыл бұрын

  • Venkat, What if we have 2 tables with same structure & 2 million records in each. one have clustered index & other don't have any index. If we write select * query without where clause? what will be the result ? I mean which will give data fast if we are not using where clause in query ?

    @bhushanjp@bhushanjp10 жыл бұрын

  • Great tutorial however i still wanted to understand how sql seeks the index as it doesn't have eyes like we have to see in Book Index :) it still need to go through row by row to fulfill the where clause right? I know not correct but I'm not convinced yet. Also if i want to fetch all records from table then i dont need to have indexes right?

    @brijendraydv@brijendraydv3 жыл бұрын

  • very helpful

    @xiaolongshen657@xiaolongshen6575 жыл бұрын
KZhead