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!
I have a better one but won't post it here...will post it on LinkedIn and watermark it so that people don't steal my idea and post it as their own...😅😅😅
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
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 ❤️❤️❤️
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!
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 !!
@@ashajyothi06 indeed, he is truly a gem. There are many other UA-camrs 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 UA-cam. He already earns enough.
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.
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!
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.
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.
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!
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
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
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
What does the key-value pair contain for the non-clustered index? You said only @8:28 employee names are stored in the key values, which is not clear to me. The rest is quite informative.
9:55 what does key value contain in non clustered index. What's the diff between k,v nodes and row locator nodes Also, why index seek shows scanned rows as 1 when db engine has to load whole page from disk containing multiple rows. Or does it exclude this from actual metric?
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.
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) ua-cam.com/play/PL08903FB7ACA1C2FB.html SQL Server Interview Questions and Answers (Very important SQL concepts in this course) ua-cam.com/play/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR.html SQL Server Performance Tuning and Query Optimization ua-cam.com/play/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0.html
5:57 why did it perform a clustered index scan on the PK instead of a table scan? What is the benefit of choosing to scan the PK rather than the table when PK doesn’t include the Name column?
Clusters index scan help to look data fastly as it is sorted . PK not include the name but than after finding pk we find the respective record and then merge both . Hope it helps.
Hello Venkat, why these videos are scattered instead of being under a playlist. You can group them under a play list name "SQL Server Performance tuning" for finding all videos at once.
Hi Tanvir - That's actually a great suggestion. Sure, I will create a separate playlist and add these to them. Thank you for the wonderful suggestion. Very helpful indeed.
Big thanks to you sir. I have one question though, if a table doesn't have a PK(clustered index) and if we try to make non-clustered index then what will the index table have in key-value pair? Memory address as value?
Hi, The second case where the record that belongs to a particular name is fetched then the physical and logical operation performed is called Clustered Index Scan even though name does not have clustered index. Why are the physical and logical operation not called table scan when we know that the SQL scans each row to fetch the row where the name is = "ABC 932000"
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🙏🙏🙏
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!
Hello @Vekant Sir, What if we don't have a clustered index on a table and only a non-clustered index on the name column. Consider there is no ID column due to poor design. In this scenario what will be the Cluster Key ( here which is the Emp ID column). Request you to elaborate this.
We always have a pk (clustered index) . But in case we not have then surrogate pk is built which is coloumn storing time stamp .i.e time at which a row was built. Hope it helps 👍
Hi venkat. Thanku for your videos. In a recent interview which i have attended, they have asked a question-->A table contains list of employees with their joining dates(ddmmyyyy) format. the interviewer asked to write a query to retrieve no of employees joined in each month for 2016 and 2018 years. can u plz help me with this Ques
Select count(*) as EmployeeCount, CONCAT (YEAR(HIREDATE),'-',MONTH(HIREDATE)) as MonthOfYear from tablename group by CONCAT (YEAR(HIREDATE),'-',MONTH(HIREDATE)) Check this
How can SQL Server read the exact address in the correct data page for the Id = 1120 when it's redirected to the data rows containing the Id intervall of 1101 - 1200? It's described as only one read of a row but how is that accomplished?
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.
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!
Good analogy.
The motels have the non-cluster indexes for sure
I have a better one but won't post it here...will post it on LinkedIn and watermark it so that people don't steal my idea and post it as their own...😅😅😅
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
100% aggred on @BEZA AR
I also agree. Very awesome explanations!
+1
Well said!!!
100% agree
Best short video on how indices work I've come across so far... This is great for a beginner.
Seriously the best instructor I've had.
This is such a great video. It takes a single concept at a time and demonstrates it in a focused and clear way.
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....
My all time favourite, finally in DB development for almost 4 years and still following u and learning new things always.
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 ❤️❤️❤️
The way you use your talent to give back to society is incredible...Thank you so much for all the things that you do.
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!
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 👊😎🙏🙏
Best explanation I ever received in 10 years of IT jobs. Thank you
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 !!
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.
Well said👌
Absolutely true🥳
Plz highlight this comment
@@ashajyothi06 indeed, he is truly a gem. There are many other UA-camrs 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 UA-cam. He already earns enough.
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.
@@aagebadho6907 your exactly correct 👏👏
One of the best videos I have come across for CI & NCI, thank you!
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!
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.
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 ??
OMG. I finally found someone to share this kind of SQL knowledge. Subscribed. ThumbsUp
What I like in your explanations not "how", but "why". Thanks
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.
haha!a very normally situation, bro! the knowledge is huge so we're just improve step by step for better.
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!
Superb explanation. I have referred other videos but non of them given this much crystal clarity on Indexes. Thank you.
Thank you so much for all of your hard work! Your videos have helped me immeasurably.
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
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
I learned lots of sql concepts from u sir... Ur a greatest human being on this planet
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
As usual, crystal n clear.
You are awesome. You nailed it bro. You explained such deep concept easily within 12 min. Must appreciate your content.
What does the key-value pair contain for the non-clustered index? You said only @8:28 employee names are stored in the key values, which is not clear to me. The rest is quite informative.
EXCELLENT VIDEO, I FINALLY UNDERSTOOD INDEXES WITH JUST THIS ONE VIDEO!
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.
Phenomenally executed video for INDEX in SQL!
9:55 what does key value contain in non clustered index. What's the diff between k,v nodes and row locator nodes
Also, why index seek shows scanned rows as 1 when db engine has to load whole page from disk containing multiple rows. Or does it exclude this from actual metric?
Thank you I always get confused and create unnecessary indexes for performance boost without reading execution plan.
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.
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.
I've been referring back to your videos for years. Thanks
Thanks man, you make the concept clear. Better than official docs.
i love you 3000 for making the index concept seem so easy and clear !
I was really struggling with this concept, came across your video. Thank you so much for this content, I really needed this.
Wow, after so many year found you again.
Thanks for great video again!
This is the best explanation I have ever come across, thank you very much
Yes ..the best SQL man..🙏❤
Brilliant Explanation for SQL Indexes !
Thanks Venkat
Your sql videos are so nice with clear explanations. Thanks lot
Thank god I came across this video 🙏 Best instructor
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)
ua-cam.com/play/PL08903FB7ACA1C2FB.html
SQL Server Interview Questions and Answers (Very important SQL concepts in this course)
ua-cam.com/play/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR.html
SQL Server Performance Tuning and Query Optimization
ua-cam.com/play/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0.html
Venkat is just awesome....⭐
Thanks for your efforts and time🤝👍
5:57 why did it perform a clustered index scan on the PK instead of a table scan? What is the benefit of choosing to scan the PK rather than the table when PK doesn’t include the Name column?
Clusters index scan help to look data fastly as it is sorted . PK not include the name but than after finding pk we find the respective record and then merge both . Hope it helps.
Always learn something new when watching your videos!
I wish i could have seen your videos before.
Highly impressed with your voice, appealing like AI
When a topic is complex and it is explained by venkat then it becomes a very simple topic
What a legend he is👏👏👏
When SQL troubles, Call venkat. Life long fan!
Just discovered this channel....got blown🤯 thank you Venkat✌️
Venkat this is just amazing. Thanks a ton!
Wow, you are incredibly smart and give the PERFECT explanation!
Thank you very much!!
Hello Venkat,
why these videos are scattered instead of being under a playlist. You can group them under a play list name "SQL Server Performance tuning" for finding all videos at once.
Hi Tanvir - That's actually a great suggestion. Sure, I will create a separate playlist and add these to them. Thank you for the wonderful suggestion. Very helpful indeed.
most asked question in interview. you are the best.
smooth, clear and to the point video... awsome
Thanks so much! I would say you are such an amazing teacher for many folks.
Big thanks to you sir. I have one question though, if a table doesn't have a PK(clustered index) and if we try to make non-clustered index then what will the index table have in key-value pair? Memory address as value?
You like the BOXER of Mohamed Ali of SQL server of all time. Thank you, Champ!
Hi,
The second case where the record that belongs to a particular name is fetched then the physical and logical operation performed is
called Clustered Index Scan even though name does not have clustered index. Why are the physical and logical operation not called table scan
when we know that the SQL scans each row to fetch the row where the name is = "ABC 932000"
Taking me to the next level - Thanks!
Your explanation is great, we can easily correlated to our thinking,
Lot of thanks
Your voice is so melodious that I just want to hear it again & again.
Hello Venkat,
Simply brilliant ! keep doing the amazing stuff !
Thanks,
Till now bestest best in sql index 🎉😊
Thank you Sir! LESSS GOOOO~~!!
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🙏🙏🙏
I AM HERE AS I WAS ASKED HOW INDEX WORK AT THE BEHIND OF THE SCENES.. SO WATCHING AND I HOPE THIS IS GONNA CLEAR MY UNDERSTANDING
your videos are teaching me more than uni
How can u explain how indexing works on composite index containing more than 2 columns
this video is gold omg brilliant
Great to listen to your voice again ☺️
You are the best of the best out there in tute land!!!
I found gold in this page. thank you brother.
I was really happy once i saw your videos.
So kind, thank you John. Means a lot.
Never seen a yt video with just 1 unlike shows all are loving the vids
Thank you Jay. Hope you found it useful too.
One word Excellent.....
Thank you Neha. Means a lot. Really glad you are finding our SQL videos useful.
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!
wow the quality of this video compared to others out there is awesome, subscribed. I will always come here for sql clarification
Thank you Venkat. You are a great knowledgeable teacher
Such an excellent explanation!!
Hello @Vekant Sir,
What if we don't have a clustered index on a table and only a non-clustered index on the name column.
Consider there is no ID column due to poor design.
In this scenario what will be the Cluster Key ( here which is the Emp ID column).
Request you to elaborate this.
We always have a pk (clustered index) . But in case we not have then surrogate pk is built which is coloumn storing time stamp .i.e time at which a row was built. Hope it helps 👍
Best video and clearly explained. Thank you!
Hi venkat. Thanku for your videos.
In a recent interview which i have attended, they have asked a question-->A table contains list of employees with their joining dates(ddmmyyyy) format.
the interviewer asked to write a query to retrieve no of employees joined in each month for 2016 and 2018 years. can u plz help me with this Ques
Select count(*) as EmployeeCount, CONCAT (YEAR(HIREDATE),'-',MONTH(HIREDATE)) as MonthOfYear from tablename group by CONCAT (YEAR(HIREDATE),'-',MONTH(HIREDATE))
Check this
@@ManishKumar-qx1kh put conditions as well as question
@@RespectNaturalBeauty which conditions?? I have given a general example u can change it according to ur need.
Let me know if there is something 🙂
Thank you, that was helpful to understand how indexes work!
What a great and concise explaination of Indexes 👍
How can SQL Server read the exact address in the correct data page for the Id = 1120 when it's redirected to the data rows containing the Id intervall of 1101 - 1200? It's described as only one read of a row but how is that accomplished?
The row “1120” is within 1001-1200
You explain simply, thank you🙏
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.
2:00 the links between intermediate pages are incorrect, indexes act as a tree not as a net.
May i know what is key value pair used in non clustered index ?
Is the Key is Primary key and its value field value
Example 932 : Alexa ?
Thanks venkat. Please make a series of Xamarin and React Native for mobile apps.
Great Video sir.. Following you from 2012.. watch your video.. repeated..
That's an honour Sumit. Really glad you are finding our courses useful. Thank you for the feedback. Means a lot.
Brilliant! Thank you!
Thank you so much for sharing this knowledge....you are genius and all your videos are great!!!
Sir learned everything about .Net from you. THANK YOU SO MUCHH