Key lookup and RID lookup in sql server execution plans

Подписаться 827 тыс.

Просмотров 52 тыс.

50% 1

Key lookup vs RID lookup | Key lookup sql server | RID lookup in sql server execution plan | Key lookup in sql server execution plan | Key lookup clustered index
Notes and Slides
www.pragimtech.com/blog/sql-o...
How SQL Indexes Work
• How do SQL Indexes Work
What is a Heap Table
• What is heap table | F...
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...
SQL Server Blog
www.pragimtech.com/courses/sq...

Наука

Опубликовано:

15 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 77

@ashajyothi06 3 года назад

Mr.kudvenkat is a super hero😎

@sarfarazmakandar4684 2 года назад

I will pray for you in my whole life whenever I write index. Huge respect sir, can't explain what you have given to me.

@sanchitvaid7017 Год назад

I did multiple certifications on SQL from reputed online learning platforms and even bought advance SQL courses on Udemy but even they do not teach these things. Hats off to you, it's because of your videos I go super confident in my interviews now.

@ninaddesai8846 2 года назад

You are best sir. Completely different level of teaching. I have watched all your SQL videos. And got a good job.👏👏👏👌👌👌

@shuvo9131 3 года назад

you are the best Venkat. I am loving this series, waiting for the next one bro

@mgstar6041 3 года назад

I would like to thank you for all the effort I have learned so much from you.

@shahabhaidar 2 года назад

This is the best explanation I've ever seen. Thanks a ton Sir. Requesting you to kindly complete the series for SQL Server Performance Tuning Videos

@georget10i 3 года назад

Excellent explanation. Thank you for creating and sharing these great videos with the world! I also like length of the videos. 5-7 minutes is perfect.

@linsfunbox4052 2 года назад

I love this video. Thank you so much! In fact, a lot of BI developers don't event know what RID lookup, Key lookup and parameter sniffing are.

@dhirajkr3758 3 года назад

Thanks Venkat for valuable information in simple way. I love and learned. Keep making valuable videos.

@kalaicompute 3 года назад

Excellent explanation of these key concepts of sql server indexes and analyzing query execution plans. I am looking for more videos about other query plans such as nested lookups.

@vishaljhaveri7565 5 месяцев назад

Thank you so much, Sir. The Perforformance Tuning Playlist is amazing. Really learnt a lot, appreciate your efforts.

@sravankumar1767 3 года назад

Nice Explanation Venkat ,Thanks For come Back with New Topics....

@ravichandraak8727 3 года назад

Super expert in explaining the tutorial to beginners keep it up and keep going venkat appreciate your efforts 👍

@kithiyongideon1629 2 года назад

Really Great! Thank you! God will bless you more because you are helping all.

@adorebeauty6539 3 года назад

Sir, please make video on INCLUDE(columns) along with non clustered index and why we don ot use it on clustered index. That is very important operation while optimizing query cuz large description(nvarchar(max)) colums slows down non clustered indexes too when they are in the select

@elainemayer8978 2 года назад

This is a great demo. Truly enjoyed your video.

@ayushisingh2139 Год назад

Hi Sir, I have been waiting for more videos of yours on this playlist.

@veerandarla9147 3 года назад

I really enjoying while watching your videos Excellent

@TheUjjwalpandey Месяц назад

Appreciate your quality content. Thanks

@kssrikanth7905 2 года назад

very easy to learn. Learnt a lot from your videos.

@mosespeter9711 Год назад

Thanks so much for the break down!

@hiphen2263 3 года назад

another best serie turtorial thank you , you are my best teacher

@dp-bhatt 2 года назад

Excellent videos. Thank you so much.

@harshitsrivastava9738 3 года назад

What an explanation you are such an inspiration sir, today all my doubts are clear. Thank you

@Csharp-video-tutorialsBlogspot 3 года назад

You are very welcome Harshit. Thank you for the feedback. Really glad you have found it useful.

@swathivasireddy1601 3 года назад

Thank you so much your vedios are very helpful than any other vedios

@sltrains Год назад

Very good video series. Thanks a lot.

@adityasethi9794 2 года назад

when we don't provide a clustered index. RID lookup happens because the engine by default creates a RID for all rows and stores them by increasing order of RID. But if we have clustered index on Id, then data is already stored in increasing order of id. Now key lookup happens. Key point is that, lookup has to happen on ordered data. RID/KEY fulfills the same purpose.

@sagarverma1250 3 года назад

Next level. You are superb sir.

@CharlieBrown0507 3 года назад

Nicely explained. Thank you

@ajay_jangra 3 года назад

Thank you sir for everything 🙏

@ameysaitavdekar4102 3 года назад

Thanks a Ton Venkat Sir.

@CK-bu5wh 9 месяцев назад

Hi Kudvenkat, I wonder if this series will be continued? or if the continued series is moved to other platform because I found your tutorial is very easy to understand and very helpful. Will looking for buy a online course regarding this topic if you're going to publish one

@siddardhasam820 2 года назад

Please do continue to post more videos.

@jasonngan5747 Год назад

Hi Venkat, thanks for the great content! Can I clarify with you, if there's no clustered index key, how does SQL do a row ID look up? Since the heap is not sorted in any particular order, when doing a row ID look up, does it imply a full table scan?

@gauravtiwari6392 2 месяца назад

Hello Venkat, Nice videos you have in all your playlists. I have a little confusion though. Like you explained that data rows get stored in leaf nodes in Clustered index, where do actual data rows get stored in Non clustered index ? All I see are row locators on leaf nodes which I am guessing are row ID based on which RID lookups get created. Also need little elaboration on key values. Thanks.

@gagandeepsingh6126 3 года назад

Hi Kudvenkat, I've been waiting for your series on SQL Server performance tuning for a long time. And you are doing awesome work on this. Please try to make this series for each physical operator of the execution plan and explain the reason behind them and what changes on SQL queries can avoid these heavy operators.

@Csharp-video-tutorialsBlogspot 3 года назад

Absolutely Gagandeep. That's the plan. Great suggestion. Thank you.

@kenji2787 3 года назад

This is very nice. Can you create a video with composite index? Like how the data is seek/scan when you have composite index on (col1, col2) but you’re only searching by col2.

@mohamedasem6523 7 месяцев назад

we hope you can continue this playlist

@vinish.maurya 3 года назад

Hi sir, We are waiting for partition table concept in sql query performance. Thanks you sir

@abdogebril3525 3 года назад

You are an awe-inspiring🤗 Can you teach us how to analyze a system and convert requirements to ERD 🌟 or anyone recommend me any source to understand this topic well.

@TechandArt 3 года назад

Good explanation 👍

@ramamohankota007 Год назад

really super bro

@cuteiffatfatima 2 года назад

I am waiting for more videos of optimization

@ankuranandwc Год назад

HI SIR, ARE WE GOING TO HAVE MORE VIDEOS ON THIS SERIES, LOOKING FORWARD TO SOME EXCELLENT QUALITY CONTENT FROM YOUR SIDE

@piraviperumal2544 3 года назад

Awesome !!

@OmkarNandgaonkar Месяц назад

The best!

@blackisblack22 Год назад

Is it a good practice to include the pk value in the section INCLUDE of a nonclustered index? Sometimes we want to know which is the table’s id for a certain indexed column and to avoid a key lookup we could read it from the index itself, is it a good idea?

@umerwaqas5943 3 года назад

Thanks sir

@murugesankgm1297 3 года назад

Very nice

@jitendrarankawat9803 3 года назад

nice and great

@viveksingh-xl2ut Год назад

Sir Please Please Make series for SQL Server performance tuning ! we are obliged to you

@karthikg108 Год назад

Hello Sir, Thank you for the detailed explanation. Quick query, please? The non-clustered index has been created based on the "Name" column only. How is the RowId column been stored in the index as a key-value pair, please? The RowId column is not even a column in the table. Also, this is table doesn't have a Primary Key column defined, then how does the RowId column has been stored in the non-clustered index, please? Could we expect more videos related to SQL Queries tuning, please?

@dreamvallyhasan4807 3 года назад

Sir please upload crystal report and report viewer series.. Thanks a lot

@avinashbhalke4653 3 года назад

Hi, Please help with difference between In and Exists. And its impact on performance

@satyamahesh89 2 года назад

Wow 😍

@justvenkyy...3423 3 года назад

can you post on sql sharding and partitioning difference

@nehakesari7190 3 года назад

This mean for small table we don't have to worry sql engine will handle by its own.

@ThanhPhamTien-vr4gf 3 месяца назад

I have question: if we only use nonclustered-index , then data is not sorted in the leaf node, then we use RID to look up , do we have to go to each page to know which data row in which page is equal to the RID that we use in the index tree ?

@nareshbuddy9522 3 года назад

Hi Bro Please help us on How to get a best execution plan

@karthik1090 3 года назад

So the RID is kind of like a primary key which is internally created by sql server for indexing purposes only as there is no primary key given by the user in the table, Right?.

@Csharp-video-tutorialsBlogspot 3 года назад

Absolutely. Spot on. It would have been good if I mentioned this. Thank you. You summarised it really well. Thank you for sharing.

@karthik1090 3 года назад

@@Csharp-video-tutorialsBlogspot if you could do some videos explaining about what is table partitioning and how it is done, that would be really helpful.

@vinish.maurya 3 года назад

@@karthik1090 yes I am also waiting

@epuriraghavendra3847 10 месяцев назад

please explain column store index

@LuigiZambetti 3 года назад

Venkat why don't you update your excellent playlist on C# to reflect the updates for version 9.0 of the language?

@Csharp-video-tutorialsBlogspot 3 года назад

Hello Luigi - Great. Suggestion. Thank you. Sure I will update it soon with all the latest and latest stuff.

@satishk4u 2 года назад

🙏

@alankarsrivastava5328 3 года назад

waiting for Execution plan video

@akashagarwal6390 Год назад

why explicitly create a new clustered index on the PK?

@agrim8863 3 года назад

Hi, Venkat I have registered for few courses on your website but none of courses have been started yet. I even dropped a mail regarding the same but no response from your end.

@Csharp-video-tutorialsBlogspot 3 года назад

Hello YIC - Very sorry, there are just too many emails and did not get time to get to them yet. Sorry, did not mean to ignore. Thank you for understanding. Can you please share the course page URL here and I will be able to help. Hope you are finding our videos useful.