How do SQL Indexes Work

  Рет қаралды 574,905

kudvenkat

kudvenkat

Күн бұрын

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

Пікірлер: 300
@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
@bezaar7762 3 жыл бұрын
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
@parshuram3238
@parshuram3238 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.Posantzis 3 жыл бұрын
Best short video on how indices work I've come across so far... This is great for a beginner.
@starmole5000
@starmole5000 3 жыл бұрын
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 2 жыл бұрын
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 3 жыл бұрын
Seriously the best instructor I've had.
@Suraaps1415
@Suraaps1415 3 жыл бұрын
My all time favourite, finally in DB development for almost 4 years and still following u and learning new things always.
@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
@dodZeus 2 жыл бұрын
Best explanation I ever received in 10 years of IT jobs. Thank you
@tommyh3524
@tommyh3524 2 жыл бұрын
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!
@abhishekkumar-sl8ow
@abhishekkumar-sl8ow 2 жыл бұрын
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....
@subhraz
@subhraz 2 жыл бұрын
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 !!
@mr.prasadyadav
@mr.prasadyadav 2 жыл бұрын
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 ❤️❤️❤️
@TheSilent333
@TheSilent333 3 жыл бұрын
Thank you so much for all of your hard work! Your videos have helped me immeasurably.
@shrusal92
@shrusal92 2 жыл бұрын
One of the best videos I have come across for CI & NCI, thank you!
@craziestkai
@craziestkai 2 жыл бұрын
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 3 жыл бұрын
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 ??
@basilio100
@basilio100 2 жыл бұрын
What I like in your explanations not "how", but "why". Thanks
@kongwengseng3735
@kongwengseng3735 3 жыл бұрын
OMG. I finally found someone to share this kind of SQL knowledge. Subscribed. ThumbsUp
@aakriti_100
@aakriti_100 2 жыл бұрын
I was really struggling with this concept, came across your video. Thank you so much for this content, I really needed this.
@brucezhou3358
@brucezhou3358 3 жыл бұрын
Thanks man, you make the concept clear. Better than official docs.
@cexploreful
@cexploreful 9 күн бұрын
EXCELLENT VIDEO, I FINALLY UNDERSTOOD INDEXES WITH JUST THIS ONE VIDEO!
@abs2645
@abs2645 2 жыл бұрын
i love you 3000 for making the index concept seem so easy and clear !
@entertolearn5000
@entertolearn5000 3 жыл бұрын
I learned lots of sql concepts from u sir... Ur a greatest human being on this planet
@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.
@mohitupadhayay1439
@mohitupadhayay1439 2 жыл бұрын
Phenomenally executed video for INDEX in SQL!
@KurtMCox
@KurtMCox 2 жыл бұрын
I've been referring back to your videos for years. Thanks
@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.
@CRBarchager
@CRBarchager 9 ай бұрын
Always learn something new when watching your videos!
@martaminale3847
@martaminale3847 2 жыл бұрын
Thanks so much! I would say you are such an amazing teacher for many folks.
@shafi123
@shafi123 2 жыл бұрын
Brilliant Explanation for SQL Indexes ! Thanks Venkat
@karmadorjee8076
@karmadorjee8076 2 жыл бұрын
Wow, after so many year found you again. Thanks for great video again!
@abderrahman9852
@abderrahman9852 Жыл бұрын
Thank you, that was helpful to understand how indexes work!
@ramanagattamaneni1184
@ramanagattamaneni1184 3 жыл бұрын
Your sql videos are so nice with clear explanations. Thanks lot
@ganeshdhareshwar6053
@ganeshdhareshwar6053 2 жыл бұрын
You are awesome. You nailed it bro. You explained such deep concept easily within 12 min. Must appreciate your content.
@RealTshepiso
@RealTshepiso 2 жыл бұрын
This is the best explanation I have ever come across, thank you very much
@severtone263
@severtone263 3 жыл бұрын
Thank you. Explained with great clarity.
@ParamitaBiswass
@ParamitaBiswass 3 ай бұрын
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.
@rvscootin3457
@rvscootin3457 4 ай бұрын
Taking me to the next level - Thanks!
@vishalmakam7291
@vishalmakam7291 3 ай бұрын
You explain simply, thank you🙏
@anupojukalyan9
@anupojukalyan9 3 жыл бұрын
Hello Venkat, Simply brilliant ! keep doing the amazing stuff ! Thanks,
@rotan90
@rotan90 5 ай бұрын
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!
@jeevant3406
@jeevant3406 2 жыл бұрын
Just discovered this channel....got blown🤯 thank you Venkat✌️
@pmshadow
@pmshadow Жыл бұрын
Wow, you are incredibly smart and give the PERFECT explanation! Thank you very much!!
@rcasturi55
@rcasturi55 3 ай бұрын
Thank you Venkat. You are a great knowledgeable teacher
@nileshpatil5644
@nileshpatil5644 Жыл бұрын
smooth, clear and to the point video... awsome
@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.
@rahulathreya3659
@rahulathreya3659 Жыл бұрын
Venkat this is just amazing. Thanks a ton!
@sarfarazamd03
@sarfarazamd03 3 жыл бұрын
Great to listen to your voice again ☺️
@ElizabethRodLom
@ElizabethRodLom 23 күн бұрын
Wow super clear and helpful, Thank you
@DesiHoonMain
@DesiHoonMain 2 жыл бұрын
What a great and concise explaination of Indexes 👍
@ChristianWDegn
@ChristianWDegn Жыл бұрын
Nice refresher video. Thanks!
@ashajyothi06
@ashajyothi06 3 жыл бұрын
Venkat is just awesome....⭐ Thanks for your efforts and time🤝👍
@Confidential007.
@Confidential007. 3 жыл бұрын
Your explanation is great, we can easily correlated to our thinking, Lot of thanks
@yfzhangphonn
@yfzhangphonn 4 ай бұрын
This is so clear, thank you for sharing
@sck29
@sck29 5 ай бұрын
Such an excellent explanation!!
@softwareengineer8923
@softwareengineer8923 29 күн бұрын
Thanks for a lucid and detailed explanation
@micci9865
@micci9865 Жыл бұрын
I found gold in this page. thank you brother.
@lasindunuwanga5292
@lasindunuwanga5292 11 ай бұрын
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
@oksanagolets577
@oksanagolets577 11 ай бұрын
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!
@sebulva
@sebulva 5 ай бұрын
Thank you very much.. Regards from Mexico
@urmisarkar6660
@urmisarkar6660 3 жыл бұрын
Very informative and helpful. Thank you Sir.
@user-zf2xe8nm5f
@user-zf2xe8nm5f 4 ай бұрын
perfect concise explanation, many thanks.
@Affliction604
@Affliction604 2 жыл бұрын
Appreciated, that's very well explained! Thanks
@basiccode-fd6xz
@basiccode-fd6xz 9 ай бұрын
your videos are teaching me more than uni
@geragamo
@geragamo 3 ай бұрын
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
@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.
@SaurabhSarang
@SaurabhSarang 3 жыл бұрын
Thank you I always get confused and create unnecessary indexes for performance boost without reading execution plan.
@avinashb4485
@avinashb4485 Жыл бұрын
Very Informative video, thanks a lot!
@prabaljain3188
@prabaljain3188 3 жыл бұрын
Sir learned everything about .Net from you. THANK YOU SO MUCHH
@mykevdc
@mykevdc 2 жыл бұрын
Very well explained, helped me a lot thank you!
@LordOfTheUniverseAndSpace
@LordOfTheUniverseAndSpace 3 жыл бұрын
As usual, crystal n clear.
@Rajukumarmsbsndb
@Rajukumarmsbsndb 2 күн бұрын
I wish i could have seen your videos before. Highly impressed with your voice, appealing like AI
@user-wz8ri2ri6m
@user-wz8ri2ri6m Ай бұрын
When a topic is complex and it is explained by venkat then it becomes a very simple topic What a legend he is👏👏👏
@pinkeshpatel1940
@pinkeshpatel1940 3 жыл бұрын
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) kzbin.info/aero/PL08903FB7ACA1C2FB SQL Server Interview Questions and Answers (Very important SQL concepts in this course) kzbin.info/aero/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR SQL Server Performance Tuning and Query Optimization kzbin.info/aero/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0
@timranft8365
@timranft8365 2 жыл бұрын
Very understandable. I really like the video!
@vikasreddy485
@vikasreddy485 2 жыл бұрын
Super clear in less time..
@aagebadho6907
@aagebadho6907 3 жыл бұрын
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 KZbinrs 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 KZbin. 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 👏👏
@kamilaknapova8557
@kamilaknapova8557 6 ай бұрын
Wow, I just understood it !!! :) thank you soooo much
@Emerald214
@Emerald214 Жыл бұрын
Thanks! I've worked with MySQL for years but didn't know the Execution Plan.
@syed_hussaini
@syed_hussaini Жыл бұрын
Your voice is so melodious that I just want to hear it again & again.
@OrcaChess
@OrcaChess 11 ай бұрын
Neat explanation to the point! Thank you :)
@Juznik1389
@Juznik1389 Жыл бұрын
Well explained, thank you!
@hyndaiaura4950
@hyndaiaura4950 2 жыл бұрын
Very well explain about indexes.
@haifa814
@haifa814 Жыл бұрын
Thank you. This is so helpful 👍🏻
@mangeshm4962
@mangeshm4962 2 жыл бұрын
Thank you so much for sharing this knowledge....you are genius and all your videos are great!!!
@swapnilurdhwareshe3672
@swapnilurdhwareshe3672 3 ай бұрын
Nicely explained and nicely organized content.
@VeryBritishEnglish
@VeryBritishEnglish 7 ай бұрын
your great! perfect tutorial. keep going
@medAmineRg
@medAmineRg 2 жыл бұрын
thats was very helpful thankyou so much bro!
@raj_kundalia
@raj_kundalia 9 ай бұрын
This was a fantastic explanation!
@sasaman5416
@sasaman5416 3 жыл бұрын
Brilliant! Thank you!
@satori8626
@satori8626 Жыл бұрын
Fantastic videos, subscribed!
@khanhnguyenba9993
@khanhnguyenba9993 3 жыл бұрын
Thank you, when i saw this video, i easy to understand
@awilgedi5819
@awilgedi5819 3 жыл бұрын
You like the BOXER of Mohamed Ali of SQL server of all time. Thank you, Champ!
@yusifkarimov6225
@yusifkarimov6225 Жыл бұрын
Thanks a lot. That's really great video.
@naveenkumar-xr9gx
@naveenkumar-xr9gx 3 жыл бұрын
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🙏🙏🙏
@johnceena9799
@johnceena9799 3 жыл бұрын
I was really happy once i saw your videos.
@Csharp-video-tutorialsBlogspot
@Csharp-video-tutorialsBlogspot 3 жыл бұрын
So kind, thank you John. Means a lot.
@RunningManNewbie
@RunningManNewbie 3 жыл бұрын
Thank you Sir! LESSS GOOOO~~!!
@keerthiBasa
@keerthiBasa Жыл бұрын
just love your videos thankyou
@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.
Indexes in sql server   Part 35
11:13
kudvenkat
Рет қаралды 823 М.
Database Indexing for Dumb Developers
15:59
Laith Academy
Рет қаралды 41 М.
ТАМАЕВ vs ВЕНГАЛБИ. Самая Быстрая BMW M5 vs CLS 63
1:15:39
Асхаб Тамаев
Рет қаралды 3,8 МЛН
ПООСТЕРЕГИСЬ🙊🙊🙊
00:39
Chapitosiki
Рет қаралды 66 МЛН
They RUINED Everything! 😢
00:31
Carter Sharer
Рет қаралды 25 МЛН
How is data stored in sql database
7:04
kudvenkat
Рет қаралды 173 М.
How do NoSQL databases work? Simply Explained!
7:38
Simply Explained
Рет қаралды 1 МЛН
What is heap table | Full table scan
11:12
kudvenkat
Рет қаралды 52 М.
How do indexes make databases read faster?
23:25
Arpit Bhayani
Рет қаралды 49 М.
SQL Indexes - Definition, Examples, and Tips
12:14
Database Star
Рет қаралды 68 М.
7 Database Paradigms
9:53
Fireship
Рет қаралды 1,5 МЛН
SQL Server Indexes Interview Questions & Answers (Basic - Part 1)
25:39
Непробиваемый телевизор 🤯
0:23
FATA MORGANA
Рет қаралды 407 М.
Iphone or nokia
0:15
rishton vines😇
Рет қаралды 1,7 МЛН
КОПИМ НА АЙФОН В ТГК АРСЕНИЙ СЭДГАПП🛒
0:59
5 НЕЛЕГАЛЬНЫХ гаджетов, за которые вас посадят
0:59
Кибер Андерсон
Рет қаралды 1,6 МЛН
Девушка и AirPods Max 😳
0:59
ОТЛИЧНИКИ
Рет қаралды 16 М.
ПОКУПКА ТЕЛЕФОНА С АВИТО?🤭
1:00
Корнеич
Рет қаралды 1,5 МЛН