KZhead
Ғылым және технология

How do SQL Indexes Work

kudvenkat
2024 ж. 20 Мам.
562 324 Рет қаралды
Жүктеу

Database index tutorial | how database indexing actually works | how does index work in sql | how sql index works
Notes and Slides
www.pragimtech.com/blog/sql-o...
SQL Server Tutorial for beginners
• SQL Server tutorial fo...
SQL Server Interview Questions and Answers
• SQL Server Interview Q...
SQL Server Performance Tuning and Query Optimization
• SQL Server Performance...

Пікірлер

  • I just realized indexes are like the signs in a hotel that help you find your room without having to search the whole floor. Thank you for the explanation!

    @robertgoodberry@robertgoodberry20 күн бұрын

  • vekant you are priceless . i dont have even words for you , you make everything crystal clear. THE ONLY MAN IN THIS WORLD WHO MAKES SQL EASIER. the way you expalin and did in example on the actual managment studio. no words for you vekant. may god bless you with abundant health and peace. thumbs up 10000000. thanks alot

    @bezaar7762@bezaar77623 жыл бұрын

    • 100% aggred on @BEZA AR

      @parshuram3238@parshuram32383 жыл бұрын

    • I also agree. Very awesome explanations!

      @paulmitchell4876@paulmitchell48763 жыл бұрын

    • +1

      @coolamitjadhav@coolamitjadhav3 жыл бұрын

    • Well said!!!

      @haregewoingebra1798@haregewoingebra17983 жыл бұрын

    • 100% agree

      @abhishekkumar-sl8ow@abhishekkumar-sl8ow2 жыл бұрын

  • Best short video on how indices work I've come across so far... This is great for a beginner.

    @Stelios.Posantzis@Stelios.Posantzis3 жыл бұрын

  • This is such a great video. It takes a single concept at a time and demonstrates it in a focused and clear way.

    @starmole5000@starmole50003 жыл бұрын

  • Seriously the best instructor I've had.

    @danimrath@danimrath3 жыл бұрын

  • Dude, I've been learning from you my entire career. Thank you so much! I hope one day I can show my appreciation for all your hard work 👊😎🙏🙏

    @teriyakov@teriyakov2 жыл бұрын

  • My all time favourite, finally in DB development for almost 4 years and still following u and learning new things always.

    @Suraaps1415@Suraaps14153 жыл бұрын

  • You're a genius! I was literally wondering how does index work in SQL Server, then your video just popped up! Can't find other videos explain index better than yours, 100% thanks!

    @tommyh3524@tommyh35242 жыл бұрын

  • The way you use your talent to give back to society is incredible...Thank you so much for all the things that you do.

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

  • Venkat, I have read numerous blogs and watched many videos on this topic but I somewhere knew I didn't fully understand the concept. After watching this video, finally I feel yes THIS IS IT. Your explanation is priceless. Thanks a ton !!

    @subhraz@subhraz2 жыл бұрын

  • I'm working in the One of MNC on SQL SERVER with out any Problems on code Part. The complete credits goes to your videos, Always You are my SQL SERVER Hero Kudvenkat Sir, Please take care about your health if you are safe Alot of people will entry their life to Software Industry with your great Lectures. No words Simply You are awesome ❤️❤️❤️

    @mr.prasadyadav@mr.prasadyadav2 жыл бұрын

  • Best explanation I ever received in 10 years of IT jobs. Thank you

    @dodZeus@dodZeus2 жыл бұрын

  • Thank you so much for all of your hard work! Your videos have helped me immeasurably.

    @TheSilent333@TheSilent3333 жыл бұрын

  • Can't be more grateful to have a youtuber like you who willing to share such good content!! I'm sure these videos save a lot of devs like me. Thank you, Sir!

    @craziestkai@craziestkai2 жыл бұрын

  • Hi Venkat, Thank you ! Only because of you I got the job as a SQL developer. I learnt a lot from these videos. God bless you....

    @abhishekkumar-sl8ow@abhishekkumar-sl8ow2 жыл бұрын

  • One of the best videos I have come across for CI & NCI, thank you!

    @shrusal92@shrusal922 жыл бұрын

  • Always learn something new when watching your videos!

    @CRBarchager@CRBarchager8 ай бұрын

  • Thanks man, you make the concept clear. Better than official docs.

    @brucezhou3358@brucezhou33583 жыл бұрын

  • I watched many other videos, those were either not useful or not covering the details to the fullest. Yo have exceeded my expectations. Thank you very much. Keep up the good work.

    @kapil4757@kapil475711 ай бұрын

  • I am really thankful to my friend who suggested me your channel. Why is it that I always come across people like you so late ??

    @jamrodhsingh2259@jamrodhsingh22593 жыл бұрын

  • I was really struggling with this concept, came across your video. Thank you so much for this content, I really needed this.

    @aakriti_100@aakriti_1002 жыл бұрын

  • This was a fantastic explanation!

    @raj_kundalia@raj_kundalia8 ай бұрын

  • OMG. I finally found someone to share this kind of SQL knowledge. Subscribed. ThumbsUp

    @kongwengseng3735@kongwengseng37353 жыл бұрын

  • When a topic is complex and it is explained by venkat then it becomes a very simple topic What a legend he is👏👏👏

    @user-wz8ri2ri6m@user-wz8ri2ri6m14 күн бұрын

  • I learned lots of sql concepts from u sir... Ur a greatest human being on this planet

    @entertolearn5000@entertolearn50003 жыл бұрын

  • You are awesome. You nailed it bro. You explained such deep concept easily within 12 min. Must appreciate your content.

    @ganeshdhareshwar6053@ganeshdhareshwar60532 жыл бұрын

  • i love you 3000 for making the index concept seem so easy and clear !

    @abs2645@abs26452 жыл бұрын

  • What I like in your explanations not "how", but "why". Thanks

    @basilio100@basilio1002 жыл бұрын

  • Thank you Kudvent! The explanation is crystal clear! I like how you speak slowly and it makes easier to follow the mass media content now is too fast to catch people's eyes and make the majority into a stressed mode.

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

  • Thank you so much, the way you explain and did in example is very easy understand. I'm sure videos save a lot of devs, like me.

    @505lab@505lab Жыл бұрын

  • Brilliant Explanation for SQL Indexes ! Thanks Venkat

    @shafi123@shafi1232 жыл бұрын

  • the example you showed by adding 1M data and retrieving one record blowed my mind. I was always thinking like how to test query optimization theories, it needs a large amount of data. This is the way. Thank you very much

    @lasindunuwanga5292@lasindunuwanga529210 ай бұрын

  • Wow, after so many year found you again. Thanks for great video again!

    @karmadorjee8076@karmadorjee80762 жыл бұрын

  • Extraordinary explanation, really really helpful

    @aieswaryaravi7853@aieswaryaravi78538 ай бұрын

  • Superb and elegant explanation

    @exe.m1dn1ght@exe.m1dn1ght9 ай бұрын

  • As usual, crystal n clear.

    @LordOfTheUniverseAndSpace@LordOfTheUniverseAndSpace3 жыл бұрын

  • Thanks so much! I would say you are such an amazing teacher for many folks.

    @martaminale3847@martaminale38472 жыл бұрын

  • Venkat is just awesome....⭐ Thanks for your efforts and time🤝👍

    @ashajyothi06@ashajyothi063 жыл бұрын

  • Phenomenally executed video for INDEX in SQL!

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

  • Your sql videos are so nice with clear explanations. Thanks lot

    @ramanagattamaneni1184@ramanagattamaneni11843 жыл бұрын

  • Yes ..the best SQL man..🙏❤

    @pramodmaurya6610@pramodmaurya66103 жыл бұрын

  • Hello Venkat, Simply brilliant ! keep doing the amazing stuff ! Thanks,

    @anupojukalyan9@anupojukalyan93 жыл бұрын

  • I've been referring back to your videos for years. Thanks

    @KurtMCox@KurtMCox2 жыл бұрын

  • Your explanation is great, we can easily correlated to our thinking, Lot of thanks

    @Confidential007.@Confidential007.3 жыл бұрын

  • This is the best explanation I have ever come across, thank you very much

    @RealTshepiso@RealTshepiso2 жыл бұрын

  • Great to listen to your voice again ☺️

    @sarfarazamd03@sarfarazamd033 жыл бұрын

  • Very nice explanation!!

    @poonam-kamboj@poonam-kamboj7 ай бұрын

  • smooth, clear and to the point video... awsome

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

  • Fantastic learning video, it cleared so many of my doubts about indexing and the hands-on was very easy to follow. Thank you for the good work.

    @ParamitaBiswass@ParamitaBiswass2 ай бұрын

  • your videos are teaching me more than uni

    @basiccode-fd6xz@basiccode-fd6xz9 ай бұрын

  • I have seen videos from Kudvenkat long back, but this is the first time I comment something here, Hey guys, this videos are awsome, very straight to the point and awesome .... thanks keep going with this videos man, they are very enjoyable

    @geragamo@geragamo2 ай бұрын

  • Thank you for those lessons about indexes - the explanations are just great! Can you please consider recording videos about covered and filtered indexes in MS SQL Server as well? Would be very grateful!

    @oksanagolets577@oksanagolets57711 ай бұрын

  • Thank you Venkat. You are a great knowledgeable teacher

    @rcasturi55@rcasturi553 ай бұрын

  • Till now bestest best in sql index 🎉😊

    @youcan_sprules@youcan_sprules11 ай бұрын

  • Wow, you are incredibly smart and give the PERFECT explanation! Thank you very much!!

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

  • What a great and concise explaination of Indexes 👍

    @DesiHoonMain@DesiHoonMain2 жыл бұрын

  • Thank you I always get confused and create unnecessary indexes for performance boost without reading execution plan.

    @SaurabhSarang@SaurabhSarang3 жыл бұрын

  • Just discovered this channel....got blown🤯 thank you Venkat✌️

    @jeevant3406@jeevant34062 жыл бұрын

  • Brilliant! Thank you!

    @sasaman5416@sasaman54163 жыл бұрын

  • Thank you Sir! LESSS GOOOO~~!!

    @RunningManNewbie@RunningManNewbie3 жыл бұрын

  • Taking me to the next level - Thanks!

    @rvscootin3457@rvscootin34574 ай бұрын

  • Every time I worried a lot 😥 how to work with db concepts. Really like the way you explain. I follow you now on. Thank you so much for making this video🙏🙏🙏

    @naveenkumar-xr9gx@naveenkumar-xr9gx2 жыл бұрын

  • Sir learned everything about .Net from you. THANK YOU SO MUCHH

    @prabaljain3188@prabaljain31882 жыл бұрын

  • Wonderfully explained, hatz off to the effort in creating quality content with images which makes very easy for students with no or beginner level db understanding. I wish such content was there when I was in school/college.

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

  • Very informative and helpful. Thank you Sir.

    @urmisarkar6660@urmisarkar66603 жыл бұрын

  • Thank you, that was helpful to understand how indexes work!

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

  • Thank you. Explained with great clarity.

    @severtone263@severtone2633 жыл бұрын

  • Venkat this is just amazing. Thanks a ton!

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

  • I found gold in this page. thank you brother.

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

  • You explain simply, thank you🙏

    @vishalmakam7291@vishalmakam72912 ай бұрын

  • This is so clear, thank you for sharing

    @yfzhangphonn@yfzhangphonn3 ай бұрын

  • Thanks for a lucid and detailed explanation

    @softwareengineer8923@softwareengineer89234 күн бұрын

  • most asked question in interview. you are the best.

    @chandanadas7860@chandanadas78603 жыл бұрын

  • Thanks, I optimized my query on 12%

    @chill9626@chill96263 жыл бұрын

  • You like the BOXER of Mohamed Ali of SQL server of all time. Thank you, Champ!

    @awilgedi5819@awilgedi58192 жыл бұрын

  • I have two technical interviews for one company this week. Company has tables with hundreds of milions of rows. With that knowledge I cannot be rejected :D thanks man!

    @rotan90@rotan904 ай бұрын

  • Hi Venkat, thanks for your videos you are really a great IT-Guru in the world of programming and database, your job done for us is really appreciable, is it possible to record MSBI(SSIS, SSAS & SSRS) videos for us, if we get your MSBI videos will really appreciate.

    @Alsn-ex4zp@Alsn-ex4zp3 жыл бұрын

  • Thank you so much for sharing this knowledge....you are genius and all your videos are great!!!

    @mangeshm4962@mangeshm49622 жыл бұрын

  • Super clear in less time..

    @vikasreddy485@vikasreddy4852 жыл бұрын

  • Very well explained, helped me a lot thank you!

    @mykevdc@mykevdc2 жыл бұрын

  • perfect concise explanation, many thanks.

    @user-zf2xe8nm5f@user-zf2xe8nm5f4 ай бұрын

  • Appreciated, that's very well explained! Thanks

    @Affliction604@Affliction6042 жыл бұрын

  • You never disappoint. I've been a dev for 4 years now and you are still the first person I go to when I need help understanding something or a refresher.

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

    • haha!a very normally situation, bro! the knowledge is huge so we're just improve step by step for better.

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

  • Which video would I need to watch for 10:35 to learn about why we need the nested loop and inner join? Seems like we should just be able to return a row once we did a clustered index lookup

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

  • Such an excellent explanation!!

    @sck29@sck294 ай бұрын

  • Thank you 🙏🏿 so much sir for your knowledge and passion.

    @WilConquer@WilConquer2 жыл бұрын

  • Nicely explained and nicely organized content.

    @swapnilurdhwareshe3672@swapnilurdhwareshe36722 ай бұрын

  • What a dedication you have. You are a man of commitment and dedication. Hats off to you. I am following you since 4 years. Huge fan.

    @aagebadho6907@aagebadho69073 жыл бұрын

    • Well said👌 Absolutely true🥳

      @ashajyothi06@ashajyothi063 жыл бұрын

    • Plz highlight this comment

      @ashajyothi06@ashajyothi063 жыл бұрын

    • @@ashajyothi06 indeed, he is truly a gem. There are many other KZheadrs who are creating many asp.net tutorial. But the moment I watched him, I thought that's the one. So since that time I started following him. He is really generous and humble I feel. If you see his details you will find that he has learnt a lot and now he wants to share his knowledge for free. He jas nothing to do with earning money from KZhead. He already earns enough.

      @aagebadho6907@aagebadho69073 жыл бұрын

    • Absolutely..! I have been following his videos too and each of them is just perfect! Can't find a better tutor than Venkat. Many concepts that I was unsure and unclear about, just got crystal clear after watching his videos. God bless him.

      @123Rajjo@123Rajjo3 жыл бұрын

    • @@aagebadho6907 your exactly correct 👏👏

      @ashajyothi06@ashajyothi063 жыл бұрын

  • Thank you so much my LORD :) you're a guardian angel

    @anishkanna92@anishkanna923 жыл бұрын

  • thanks kudvenkat for the video

    @Technology-Posts@Technology-Posts3 жыл бұрын

  • Thank you. This is so helpful 👍🏻

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

  • this video is gold omg brilliant

    @coding3438@coding34382 жыл бұрын

  • your great! perfect tutorial. keep going

    @VeryBritishEnglish@VeryBritishEnglish7 ай бұрын

  • Thank you Sir🙏

    @MrShreedar@MrShreedar3 жыл бұрын

  • Nice refresher video. Thanks!

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

  • Thank you for the great tutorial

    @srinivasrao8863@srinivasrao88632 жыл бұрын

  • U have a great voice and explanation 💯

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

  • Thank you, when i saw this video, i easy to understand

    @khanhnguyenba9993@khanhnguyenba99933 жыл бұрын

  • Thank you very much.. Regards from Mexico

    @sebulva@sebulva5 ай бұрын

  • Well explained, thank you!

    @Juznik1389@Juznik1389 Жыл бұрын
KZhead