How do SQL Indexes Work

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

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...

Пікірлер: 299

  • @robertgoodberry
    @robertgoodberryАй бұрын

    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!

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

    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

  • @parshu3238

    @parshu3238

    3 жыл бұрын

    100% aggred on @BEZA AR

  • @paulmitchell4876

    @paulmitchell4876

    3 жыл бұрын

    I also agree. Very awesome explanations!

  • @coolamitjadhav

    @coolamitjadhav

    3 жыл бұрын

    +1

  • @haregewoingebra1798

    @haregewoingebra1798

    3 жыл бұрын

    Well said!!!

  • @abhishekkumar-sl8ow

    @abhishekkumar-sl8ow

    2 жыл бұрын

    100% agree

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

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

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

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

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

    Seriously the best instructor I've had.

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

    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 👊😎🙏🙏

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

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

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

    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!

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

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

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

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

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

    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 ❤️❤️❤️

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

    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 !!

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

    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....

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

    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!

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

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

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

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

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

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

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

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

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

    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 ??

  • @mohitupadhayay1439
    @mohitupadhayay14392 жыл бұрын

    Phenomenally executed video for INDEX in SQL!

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

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

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

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

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

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

  • @cexploreful
    @cexploreful20 күн бұрын

    EXCELLENT VIDEO, I FINALLY UNDERSTOOD INDEXES WITH JUST THIS ONE VIDEO!

  • @kapil4757
    @kapil4757 Жыл бұрын

    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.

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

    Brilliant Explanation for SQL Indexes ! Thanks Venkat

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

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

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

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

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

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

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

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

  • @rvscootin3457
    @rvscootin34575 ай бұрын

    Taking me to the next level - Thanks!

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

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

  • @CRBarchager
    @CRBarchager9 ай бұрын

    Always learn something new when watching your videos!

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

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

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

    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.

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

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

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

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

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

    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.

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

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

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

    Thank you. Explained with great clarity.

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

    Venkat this is just amazing. Thanks a ton!

  • @lasindunuwanga5292
    @lasindunuwanga529211 ай бұрын

    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

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

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

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

    As usual, crystal n clear.

  • @rotan90
    @rotan905 ай бұрын

    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!

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

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

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

    Nice refresher video. Thanks!

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

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

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

    Great to listen to your voice again ☺️

  • @geragamo
    @geragamo3 ай бұрын

    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

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

    I found gold in this page. thank you brother.

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

    Brilliant! Thank you!

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

    Thank you Sir! LESSS GOOOO~~!!

  • @vishalmakam7291
    @vishalmakam72914 ай бұрын

    You explain simply, thank you🙏

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

    Super clear in less time..

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

    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.

  • @KiddyLovely93

    @KiddyLovely93

    Жыл бұрын

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

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

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

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

    Yes ..the best SQL man..🙏❤

  • @sebulva
    @sebulva6 ай бұрын

    Thank you very much.. Regards from Mexico

  • @ParamitaBiswass
    @ParamitaBiswass4 ай бұрын

    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.

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

    What a great and concise explaination of Indexes 👍

  • @pinkeshpatel1940
    @pinkeshpatel19403 жыл бұрын

    Thank god I came across this video 🙏 Best instructor

  • @Csharp-video-tutorialsBlogspot

    @Csharp-video-tutorialsBlogspot

    3 жыл бұрын

    Thank you Pinkesh. Means a lot. You can find all our free SQL Server courses below. Hope you will find them useful. SQL Server Tutorial for Beginners (All the basic and advanced concepts) kzread.info/head/PL08903FB7ACA1C2FB SQL Server Interview Questions and Answers (Very important SQL concepts in this course) kzread.info/head/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR SQL Server Performance Tuning and Query Optimization kzread.info/head/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0

  • @ElizabethRodLom
    @ElizabethRodLomАй бұрын

    Wow super clear and helpful, Thank you

  • @yfzhangphonn
    @yfzhangphonn4 ай бұрын

    This is so clear, thank you for sharing

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

    Appreciated, that's very well explained! Thanks

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

    this video is gold omg brilliant

  • @prabaljain3188
    @prabaljain31883 жыл бұрын

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

  • @sck29
    @sck295 ай бұрын

    Such an excellent explanation!!

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

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

  • @rcasturi55
    @rcasturi554 ай бұрын

    Thank you Venkat. You are a great knowledgeable teacher

  • @oksanagolets577
    @oksanagolets577 Жыл бұрын

    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!

  • @Rajukumarmsbsndb
    @Rajukumarmsbsndb13 күн бұрын

    I wish i could have seen your videos before. Highly impressed with your voice, appealing like AI

  • @softwareengineer8923
    @softwareengineer8923Ай бұрын

    Thanks for a lucid and detailed explanation

  • @naveenkumar-xr9gx
    @naveenkumar-xr9gx3 жыл бұрын

    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🙏🙏🙏

  • @awilgedi5819
    @awilgedi58193 жыл бұрын

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

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

    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.

  • @johnceena9799
    @johnceena97993 жыл бұрын

    I was really happy once i saw your videos.

  • @Csharp-video-tutorialsBlogspot

    @Csharp-video-tutorialsBlogspot

    3 жыл бұрын

    So kind, thank you John. Means a lot.

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

    Thanks, I optimized my query on 12%

  • @kamilaknapova8557
    @kamilaknapova85577 ай бұрын

    Wow, I just understood it !!! :) thank you soooo much

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

    Very well explained, helped me a lot thank you!

  • @keerthiBasa
    @keerthiBasa Жыл бұрын

    just love your videos thankyou

  • @avinashb4485
    @avinashb4485 Жыл бұрын

    Very Informative video, thanks a lot!

  • @murugesankgm1297
    @murugesankgm12973 жыл бұрын

    No words. Super.

  • @user-zf2xe8nm5f
    @user-zf2xe8nm5f5 ай бұрын

    perfect concise explanation, many thanks.

  • @mydodethailung395
    @mydodethailung395 Жыл бұрын

    WOOOOW so clear!!!!

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

    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.

  • @ashajyothi06

    @ashajyothi06

    3 жыл бұрын

    Well said👌 Absolutely true🥳

  • @ashajyothi06

    @ashajyothi06

    3 жыл бұрын

    Plz highlight this comment

  • @aagebadho6907

    @aagebadho6907

    3 жыл бұрын

    @@ashajyothi06 indeed, he is truly a gem. There are many other KZreadrs 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 KZread. He already earns enough.

  • @123Rajjo

    @123Rajjo

    3 жыл бұрын

    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.

  • @ashajyothi06

    @ashajyothi06

    3 жыл бұрын

    @@aagebadho6907 your exactly correct 👏👏

  • @basiccode-fd6xz
    @basiccode-fd6xz10 ай бұрын

    your videos are teaching me more than uni

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

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

  • @timranft8365
    @timranft83652 жыл бұрын

    Very understandable. I really like the video!

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

    Very informative and helpful. Thank you Sir.

  • @Emerald214
    @Emerald214 Жыл бұрын

    Thanks! I've worked with MySQL for years but didn't know the Execution Plan.

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

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

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

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

  • @raj_kundalia
    @raj_kundalia9 ай бұрын

    This was a fantastic explanation!

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

    Well explained, thank you!

  • @VeryBritishEnglish
    @VeryBritishEnglish8 ай бұрын

    your great! perfect tutorial. keep going

  • @youcan_sprules
    @youcan_sprules Жыл бұрын

    Till now bestest best in sql index 🎉😊

  • @medAmineRg
    @medAmineRg2 жыл бұрын

    thats was very helpful thankyou so much bro!

  • @kunststofffantastisch5690
    @kunststofffantastisch56903 жыл бұрын

    You are the best of the best out there in tute land!!!

  • @yusifkarimov6225
    @yusifkarimov6225 Жыл бұрын

    Thanks a lot. That's really great video.

Келесі