How do SQL Indexes Work

Sdílet
Vložit
  • čas přidán 4. 07. 2024
  • 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...
  • Věda a technologie

Komentáře • 300

  • @robertgoodberry
    @robertgoodberry Před 2 měsíci +25

    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
    @bezaar7762 Před 3 lety +243

    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

  • @Stelios.Posantzis
    @Stelios.Posantzis Před 3 lety +8

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

  • @starmole5000
    @starmole5000 Před 3 lety +14

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

  • @teriyakov
    @teriyakov Před 2 lety +12

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

  • @danimrath
    @danimrath Před 3 lety +15

    Seriously the best instructor I've had.

  • @tommyh3524
    @tommyh3524 Před 2 lety +1

    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!

  • @Suraaps1415
    @Suraaps1415 Před 3 lety +3

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

  • @capsonfernandes4803
    @capsonfernandes4803 Před rokem +2

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

  • @subhraz
    @subhraz Před 2 lety

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

  • @dodZeus
    @dodZeus Před 2 lety +1

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

  • @abhishekkumar-sl8ow
    @abhishekkumar-sl8ow Před 2 lety +1

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

  • @mr.prasadyadav
    @mr.prasadyadav Před 2 lety +8

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

  • @shrusal92
    @shrusal92 Před 3 lety

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

  • @craziestkai
    @craziestkai Před 2 lety

    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!

  • @jamrodhsingh2259
    @jamrodhsingh2259 Před 3 lety +2

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

  • @kongwengseng3735
    @kongwengseng3735 Před 3 lety

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

  • @kapil4757
    @kapil4757 Před rokem

    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.

  • @TheSilent333
    @TheSilent333 Před 3 lety +6

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

  • @brucezhou3358
    @brucezhou3358 Před 3 lety

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

  • @aakriti_100
    @aakriti_100 Před 2 lety

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

  • @abs2645
    @abs2645 Před 2 lety

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

  • @basilio100
    @basilio100 Před 3 lety

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

  • @ganeshdhareshwar6053
    @ganeshdhareshwar6053 Před 2 lety +1

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

  • @mohitupadhayay1439
    @mohitupadhayay1439 Před 2 lety

    Phenomenally executed video for INDEX in SQL!

  • @cexploreful
    @cexploreful Před 29 dny

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

  • @entertolearn5000
    @entertolearn5000 Před 3 lety

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

  • @KurtMCox
    @KurtMCox Před 2 lety

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

  • @karmadorjee8076
    @karmadorjee8076 Před 2 lety

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

  • @shafi123
    @shafi123 Před 2 lety

    Brilliant Explanation for SQL Indexes !
    Thanks Venkat

  • @505lab
    @505lab Před rokem +1

    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.

  • @ramanagattamaneni1184
    @ramanagattamaneni1184 Před 3 lety

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

  • @CRBarchager
    @CRBarchager Před 10 měsíci

    Always learn something new when watching your videos!

  • @ParamitaBiswass
    @ParamitaBiswass Před 4 měsíci

    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.

  • @alexpajp123
    @alexpajp123 Před rokem +1

    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 Před rokem

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

  • @geragamo
    @geragamo Před 3 měsíci

    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

  • @anupojukalyan9
    @anupojukalyan9 Před 3 lety

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

  • @yig8763
    @yig8763 Před rokem

    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.

  • @RealTshepiso
    @RealTshepiso Před 2 lety

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

  • @jeevant3406
    @jeevant3406 Před 2 lety

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

  • @martaminale3847
    @martaminale3847 Před 2 lety

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

  • @LordOfTheUniverseAndSpace
    @LordOfTheUniverseAndSpace Před 3 lety +12

    As usual, crystal n clear.

  • @ashajyothi06
    @ashajyothi06 Před 3 lety +10

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

  • @lasindunuwanga5292
    @lasindunuwanga5292 Před rokem

    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

  • @rahulathreya3659
    @rahulathreya3659 Před rokem

    Venkat this is just amazing. Thanks a ton!

  • @pmshadow
    @pmshadow Před rokem

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

  • @rvscootin3457
    @rvscootin3457 Před 5 měsíci

    Taking me to the next level - Thanks!

  • @abderrahman9852
    @abderrahman9852 Před rokem

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

  • @SaurabhSarang
    @SaurabhSarang Před 3 lety +5

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

  • @rotan90
    @rotan90 Před 6 měsíci

    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!

  • @nitiniit07
    @nitiniit07 Před rokem

    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.

  • @oksanagolets577
    @oksanagolets577 Před rokem +3

    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!

  • @sarfarazamd03
    @sarfarazamd03 Před 3 lety +1

    Great to listen to your voice again ☺️

  • @nileshpatil5644
    @nileshpatil5644 Před rokem

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

  • @severtone263
    @severtone263 Před 3 lety

    Thank you. Explained with great clarity.

  • @Confidential007.
    @Confidential007. Před 3 lety +1

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

  • @RunningManNewbie
    @RunningManNewbie Před 3 lety +5

    Thank you Sir! LESSS GOOOO~~!!

  • @naveenkumar-xr9gx
    @naveenkumar-xr9gx Před 3 lety

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

  • @DesiHoonMain
    @DesiHoonMain Před 2 lety

    What a great and concise explaination of Indexes 👍

  • @ChristianWDegn
    @ChristianWDegn Před rokem

    Nice refresher video. Thanks!

  • @sasaman5416
    @sasaman5416 Před 3 lety +3

    Brilliant! Thank you!

  • @vishalmakam7291
    @vishalmakam7291 Před 4 měsíci

    You explain simply, thank you🙏

  • @Rajukumarmsbsndb
    @Rajukumarmsbsndb Před 21 dnem

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

  • @prabaljain3188
    @prabaljain3188 Před 3 lety

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

  • @ElizabethRodLom
    @ElizabethRodLom Před měsícem

    Wow super clear and helpful, Thank you

  • @sebulva
    @sebulva Před 6 měsíci

    Thank you very much.. Regards from Mexico

  • @rcasturi55
    @rcasturi55 Před 4 měsíci

    Thank you Venkat. You are a great knowledgeable teacher

  • @pramodmaurya6610
    @pramodmaurya6610 Před 3 lety +2

    Yes ..the best SQL man..🙏❤

  • @pinkeshpatel1940
    @pinkeshpatel1940 Před 3 lety +1

    Thank god I came across this video 🙏 Best instructor

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  Před 3 lety

      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)
      czcams.com/play/PL08903FB7ACA1C2FB.html
      SQL Server Interview Questions and Answers (Very important SQL concepts in this course)
      czcams.com/play/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR.html
      SQL Server Performance Tuning and Query Optimization
      czcams.com/play/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0.html

  • @Affliction604
    @Affliction604 Před 3 lety

    Appreciated, that's very well explained! Thanks

  • @micci9865
    @micci9865 Před rokem

    I found gold in this page. thank you brother.

  • @aagebadho6907
    @aagebadho6907 Před 3 lety +9

    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 Před 3 lety +1

      Well said👌
      Absolutely true🥳

    • @ashajyothi06
      @ashajyothi06 Před 3 lety +2

      Plz highlight this comment

    • @aagebadho6907
      @aagebadho6907 Před 3 lety +1

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

    • @123Rajjo
      @123Rajjo Před 3 lety +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 Před 3 lety

      @@aagebadho6907 your exactly correct 👏👏

  • @sck29
    @sck29 Před 6 měsíci +1

    Such an excellent explanation!!

  • @yfzhangphonn
    @yfzhangphonn Před 4 měsíci

    This is so clear, thank you for sharing

  • @vikasreddy485
    @vikasreddy485 Před 2 lety

    Super clear in less time..

  • @Emerald214
    @Emerald214 Před rokem

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

  • @awilgedi5819
    @awilgedi5819 Před 3 lety

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

  • @softwareengineer8923
    @softwareengineer8923 Před měsícem

    Thanks for a lucid and detailed explanation

  • @timranft8365
    @timranft8365 Před 2 lety

    Very understandable. I really like the video!

  • @mangeshm4962
    @mangeshm4962 Před 2 lety

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

  • @chandanadas7860
    @chandanadas7860 Před 3 lety +3

    most asked question in interview. you are the best.

  • @johnceena9799
    @johnceena9799 Před 3 lety

    I was really happy once i saw your videos.

  • @basiccode-fd6xz
    @basiccode-fd6xz Před 10 měsíci

    your videos are teaching me more than uni

  • @syed_hussaini
    @syed_hussaini Před rokem

    Your voice is so melodious that I just want to hear it again & again.

  • @kamilaknapova8557
    @kamilaknapova8557 Před 7 měsíci

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

  • @avinashb4485
    @avinashb4485 Před rokem

    Very Informative video, thanks a lot!

  • @urmisarkar6660
    @urmisarkar6660 Před 3 lety +2

    Very informative and helpful. Thank you Sir.

  • @mykevdc
    @mykevdc Před 2 lety

    Very well explained, helped me a lot thank you!

  • @Alsn-ex4zp
    @Alsn-ex4zp Před 3 lety +2

    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.

  • @kunststofffantastisch5690

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

  • @coding3438
    @coding3438 Před 2 lety

    this video is gold omg brilliant

  • @raj_kundalia
    @raj_kundalia Před 10 měsíci

    This was a fantastic explanation!

  • @user-zf2xe8nm5f
    @user-zf2xe8nm5f Před 5 měsíci

    perfect concise explanation, many thanks.

  • @emanuelzhupa
    @emanuelzhupa Před 2 lety

    Very well explained. thumbs-up 👍, Hopefully you create more content on these topics. 🙌

  • @satori8626
    @satori8626 Před rokem

    Fantastic videos, subscribed!

  • @user-wz8ri2ri6m
    @user-wz8ri2ri6m Před 2 měsíci

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

  • @chill9626
    @chill9626 Před 3 lety

    Thanks, I optimized my query on 12%

  • @keerthiBasa
    @keerthiBasa Před rokem

    just love your videos thankyou

  • @OrcaChess
    @OrcaChess Před rokem

    Neat explanation to the point! Thank you :)

  • @VeryBritishEnglish
    @VeryBritishEnglish Před 8 měsíci

    your great! perfect tutorial. keep going