SQL performance tuning and query optimization using execution plan

[@mohammedminhajulhaq5542]

We need to share this kind of videos to maximum people. This is much underrated in terms of views. A lot to learn from this video. Thank you sooo much for keeping it simple and understandable. We can't get this much of advise and knowledge after paying also. Attended some pluralsite videos of some SQL experts but didn't understand a bit but in this 1 video got so much of information. Thanks a ton once again. Keep it up good work 👍👍👍👍

[@techsapphire]

Thanks. Note: I also provide commercial support. Please contact if needed. If you find this solution helpful than donate comfortable amount on papal to my email ID or link www.paypal.me/bimlamehla. Donation is not mandatory is it just request to support free tutorial.

[@parthasarathiramachandran8189]

@@techsapphire can we have your contact number or whatsapp number/ email id

[@sharmavasundhara]

This is by far the best SQL query optimization videos I've watched! I'm going to share this with everyone I know who can benefit from this. Thanks @techsapphire 🙌🏽

[@srinubathina9096]

This is the best class in terms of SQL Performance Tuning. Thank You..

[@techsapphire]

Glad you like it!

[@palashmondal9088]

I asked to optimize query by product owner after that start watching your video, it help me a lot. Thank you so much!!

[@techsapphire]

Glad it helped!

[@dbamentorparag]

I am in Adelaide Australia and watching your video

[@techsapphire]

awesome :) nice to see you here in comment as well.

[@prabasmessi]

Thank you so much for sharing the knowledge. Best explanation for query optimization i have seen till now.

[@techsapphire]

Glad it was helpful!

[@mithunraj31]

Really this is one of the BEST video ever, so easy to understand. Very very very helpful. Thanks a lot for this brilliant one.

[@techsapphire]

Glad it was helpful!

[@venkatasumanbhavanasi6939]

Hi yogesh, this is really helpful for developers who donno the concepts and tricks to optimize queries and simply writing the queries as their own which makes client in bad situation. This video helped me alot. Thank you..

[@techsapphire]

Glad it was helpful!

[@Penjarlamahesh]

Excellent teaching skill, your explanation is very clear and very easy to understand ❤

[@techsapphire]

Glad to hear that

[@mrkamranumer]

Wonderful and Excellent Knowledge based in-depth Performance Tuning Video

[@techsapphire]

Glad you liked it!

[@kaustubhpradhan82]

Extremely helpful. Searched a lot for help and video stands out to be unique. Thank you. :-)

[@techsapphire]

Glad you find it good

[@nitsz07]

Thanks! Thanks a lot Yogesh for your time and efforts in this particular video. This helped me a lot..

[@techsapphire]

Glad it helped

[@dattakashiwale]

Excellent ! outstanding video., most of the concept were unknown.., really helped a lot., thanks a lot Bhai.., pls create more stuff like this..,

[@techsapphire]

Thank you, I will

[@maruthibachu8854]

Really its awesome.. Its helped lot and easy to understand.. please make more videos. thank you

[@techsapphire]

Thank you, I will

[@DIZS_PVT_LTD]

Very Good Lecture gives me so much clarity.

[@techsapphire]

Glad it was helpful!

[@satheeshkandukurii5251]

Really awesome...pls do more videos on performance tuning

[@jagjeetrathore9122]

i watched many videos , found this one awesome for beginners

[@techsapphire]

Thank you for your feedback.

[@DineshArya-n9l]

Amazing tutorial on query tuning... thanks a lot

[@jaredlising-simplybrewedph]

Thank you so much for such detailed explanation! Appreciate it so much! 😊

[@techsapphire]

Glad it was helpful!

[@xx_ggplot2_xx]

Insanely good video. Helped for my DE interview

[@techsapphire]

Glad it helped! I provide training as well.

[@shreyadutta5817]

Very informative... Brilliantly explained

[@techsapphire]

Glad you liked it

[@deebanm124]

Thank you for this video. This is very helpful and it helps me to understand how the execution plan work. I need a scripts.

[@techsapphire]

You can find the scripts in the video description.

[@kaushikkrishnan5828]

Amazing, super helpful to get a direction on how to go about optimizing queries

[@techsapphire]

Glad it was helpful!

[@dishantrana341]

This is just amazing, going to share with all mates.

[@techsapphire]

Glad you find it helpful

[@devarakondasankararao3802]

Very excellent video .Thank you so much for this explanation.

[@techsapphire]

Glad it was helpful!

[@ashwineemehta9449]

I went though this video and found it very useful.

[@techsapphire]

Glad it was helpful!

[@parixitsinhchauhan5186]

nicely explained every topic. Good Video

[@techsapphire]

Glad you liked it

[@Sk8erBhai]

Great video, brother. Have learnt so much so quick

[@techsapphire]

Glad to hear it!

[@vijayalakshmibadigeru4479]

Really great video... We look forward to learn more ✌️

[@techsapphire]

Glad you liked it

[@deepak21000]

Excellent performance tuning tutorial

[@techsapphire]

Glad you liked it!

[@nandiniguntur4509]

Good job. The explanation is very succint

[@techsapphire]

Glad it was helpful!

[@karthikkeyan4460]

Timstamps for various topics covered.. 18:21 Hashmatch 23:54 KeyLookup

[@gokuls3000]

this is best video for performance tuning

[@techsapphire]

Thank you for positive feedback

[@kuldeepsharma3822]

Bro ek no.. explained very well ...

[@techsapphire]

Nice to hear that, I will be uploading more videos on similar topics.

[@ganeshvarma370]

Learned So much, Keep doing more videos. Respect++

[@techsapphire]

Thanks, will do!

[@bluerays5384]

very explained Sir, Thank you for the video.

[@techsapphire]

Glad it helped

[@bluerays5384]

I watched your video might be 4th or 5th time today, N every time I learn something new n brings my knowledge to next level..Very well explained sir. Keep Sharing such a live scenario n knowledge..This helped me lot..lots of love sir #bow ❤❤❤❤

[@saikumarramisetty]

Thank you so much for the awesome video, I got a clear idea about the Performance tuning

[@techsapphire]

Glad it helped!

[@saurabhashok2857]

Simply outstanding explanation. Thanks!

[@techsapphire]

Glad it was helpful!

[@DD-dp6ge]

Amazing, very well explained, thanks!

[@techsapphire]

Glad it was helpful!

[@ravindark646]

Nice explanation and got clear Idea on the such things. Thanks :)

[@techsapphire]

Glad it was helpful!

[@mahaalsalman2323]

Thank you for good teaching you explained it very clearly

[@techsapphire]

Glad it was helpful!

[@haribabunaiduyasanoor5233]

Excellent session Sir!!

[@techsapphire]

Glad you liked it!

[@ArundheerajYellutla]

Thanks for your detail explanation

[@techsapphire]

Glad it was helpful!

[@priyankasarkar6600]

Awesome Sir..:) On point tutorial! Please make more videos on triggers, cluster, cursor.. Thanks in advance..:)

[@techsapphire]

Sure thing! Keep learning :)

[@srikanthkurra9513]

Thanks for the complete explanation

[@techsapphire]

Glad it was helpful!

[@calvinball1]

This is an astoundingly good video

[@techsapphire]

I'm glad you like it

[@ManishPurohit-gl6lq]

It's a brilliant explanation.

[@techsapphire]

Glad you liked it

[@dbatexas]

thanks for details, video could be more in depth like why nested loop join vs hash join, what is lazy pool or eager spool/spills. but other than all good concepts and topics. it takes times to explain all details so we could give links for people to learn like nested loop runtime is O(n2) Vs merge join O(nLogN) etc etc

[@techsapphire]

Thank you for your feedback. Reason why I haven't covered details about latches and waits and why nested loops, etc is, mostly I make video for intermediate learner to expert level. And if I add these stuff, video become confusing for them, I tried to cover in best lehman terms. But I agree for some viewer details make more sense, but mostly people I train are not good with basics so, difficult to bring them in same page.

[@pravaspatra3849]

Its very helpful. Please share more videos

[@P5toraskar1986]

Superb information.

[@techsapphire]

Thanks a lot

[@erashusri]

Thank you very much for all your effort.

[@techsapphire]

Always welcome

[@poojagarg5673]

Thanks a lot for sharing this video, it's very informative and helped me understand many concepts. Right now, I am looking at a complex query plan which is timing out(query) pretty often. That execution plan has many operations like Index seek (NonClusered), Clustered Index Scan, Clustered Index Seek etc. Please explain these terms as well. These are quite confusing when reading the definition of these.

[@techsapphire]

I provide 1 to 1 session which comes up with a fee to clear your all doubts, if you are interested kindly reach me on [e-mail]

[@sandeepkumar-ol5lg]

Great content, as you mentioned it’s one out of two parts, could you please comment the second video link here

[@techsapphire]

Post this video, there are many videos on how to capture expensive queries etc. You can check

[@Rprakaash]

have you used sql sentry plan explorer? what is your opinion about it. I find it really facinating. I wish they had more vidoes on that.

[@darrylw99]

where did you get the extra tables in your Northwind, mine only has 9 tables

[@010_it_daithiyasudanks3]

I am trying to reproduce the same steps in my machine. I am not able to find Student table under Northwind database. Can you please where I can find the scripts for that? This video is starting to be very useful for me.

[@labs_with_om]

Awesome, just below excellent,

[@techsapphire]

Thank you so much 😀

[@waqarbaig1402]

this is realy good picture of optimization .. also please add sql profiler in terms of optmization

[@techsapphire]

Thank you for your feedback. I will add session on sql profiler too.

[@niha46]

nice explanation, very helpful.

[@techsapphire]

Glad it was helpful!

[@yogisawant9891]

Nice video. Thank you sir

[@techsapphire]

Most welcome

[@anuragjains2195]

Nicely explained. Thank you very much!

[@techsapphire]

Thank you for your feedback.

[@codearabawy]

That's awesome, thank you very much!

[@techsapphire]

You're very welcome!

[@SandeepYadav-vm5hd]

Amazing Video Very useful !!!

[@techsapphire]

Glad it was helpful!

[@Shad0wMonkey5]

This was such a good video I’m shocked ahahaha! Do you have any more optimisation tips and how diagnosing slow queries?

[@techsapphire]

Yes I do! Alot are on my channel kindly check, I also provide commercial sessions

[@NareshDama-qv3iu]

Very useful information.. thank you so much!!

[@kaushikbudi8819]

Hello Sir great video just had a small doubt how would the performance be if we used last value for the example problem for minimizing sub queries

[@techsapphire]

single query will not have major impact, its important to have most of the queries to be optimized to ensure good performance

[@pavankumarcheruvu8207]

Hi sir, It was nice video. I have one doubt while explaining you're telling everytime about sql server but I'm not using sql server in my project I'm using sql developer tool and I'm working as sql developer, So it is same for all ? Please reply me.

[@techsapphire]

Yes, correct. Performance optimization using query tuning is mainly job of SQL Dev not DBA

[@Latif127]

Very helpful tutorial, thank you.

[@techsapphire]

Glad it was helpful!

[@yashpatil2536]

Amazing Thank you so much!

[@techsapphire]

Glad you like it!

[@karanrewari6482]

amazing video!! very helpful, thanks!

[@techsapphire]

Glad you found it helpful.

[@gomathyelango5574]

Is this query tuning applicable to oracle database as well?

[@techsapphire]

yes query mistakes are common

[@anonymous8633]

how to avoid key lookup when PK_clusteredIndex seek is in the exec. plan? I know if, non clustered on exec. plan, I can add those columns to the index but what to do with key lookup and PK_seek?

[@techsapphire]

lookup are tricky to fix, depends on your instinct to fix them as they can cause more locks for insert delete and update if you add more columns

[@dinsharma1409]

What version is the NorthWind database? Mine doesn't have the 'Student' column. Would you please paste the URL here to get the same Database you have on your presentation?

[@techsapphire]

follow link in description for database backup

[@dinsharma1409]

@@techsapphire Where is the link?

[@ranjitreddy6316]

Thanks Much For this video! Really appreciate it! :)

[@techsapphire]

Glad it was helpful!

[@dishaverma3522]

Thanks allot it's really helpful

[@techsapphire]

You're welcome!

[@sid5201]

Hash Join is not always bad, especially dealing with very large tables.

[@techsapphire]

There is no term like always bad. It depends, if you are joining complex views, you may not be able to avoid hash join. So SQL decision is good, we have to form are query accordingly.

[@sid5201]

@@techsapphire agree

[@jegadeesr7213]

While optimizing T-SQL Queries, in the logical query execution plan, what are the top 3 operators which we should eliminate / optimize?

[@techsapphire]

Lazy spool one and only other are more dependent on situation

[@Jogukrish]

outstanding Sir

[@techsapphire]

Many thanks

[@kjkanishk7575]

thanks ... :) ... really great presentation.

[@techsapphire]

Glad you liked it!

[@ManOfAdventure2011]

Great tutorial! I learned a lot!

[@techsapphire]

Glad it was helpful!

[@bharath.vkumar5941]

really like this video........may get any suggestions currently, i working for my thesis on the topic of RESEARCH ON AI APPLICATION FOR OPTIMIZATION OF THE SQL QUERIES..

[@techsapphire]

Is your research only SQL Server or other databases as well?

[@kiran3243]

nice video sir

[@techsapphire]

Thanks and welcome

[@PrakashPatil-dw5be]

I have a table with more than 100 columns, so how many indexes can create for a single table?

[@techsapphire]

there is no hard rule for it, depends upon you infrastructure and also sql version. Enterprise can go manage crazy load of indexes. Index should be created sensibly.

[@RajeshKumar-nc5gg]

Very very nice

[@techsapphire]

Thanks a lot

[@amiya217]

good explanation..

[@techsapphire]

Thanks and welcome

[@sangeetatulsiyan314]

Thank you, can you please share this ppt and example queries.

[@techsapphire]

mail me at [e-mail]

[@rainmaker168]

Thanks. Please share the init db script for Student Table.

[@aloksinha6342]

Very nice explanation.One of the best.Could you please share the scripts also..

[@techsapphire]

Please share your email

[@el-mehdichouki6355]

Hello Yogesh sir, Can we get the ppt, DB and the scripts ? Thanks. I learned a lot from this video.

[@techsapphire]

Kindly share your email

[@el-mehdichouki6355]

​@@techsapphire i sent you a mail

[@nilamsherkar]

can i get this database to practice the questions

[@munukuntlaprashanth4918]

Hi, I am having issue with stored procedure as it is taking huge time.. Can you please help me

[@techsapphire]

I provide commercial support

[@martinhedmanjohnson6687]

Hi Yogesh, at one point you mention "group before, not after" what do yuo mean by that?

[@techsapphire]

I am confused about reference, if you want to discuss in detail, kindly reach me on skype [e-mail]

[@avirajankitjain256]

from where i can get the data ?

[@techsapphire]

kindly mail me at [e-mail]

[@PrakashPatil-dw5be]

good information...

[@techsapphire]

Thanks

[@Firatayrilik]

Hello. Thanks for the video. What exactly 'Double Aggregation' means? I mean I only see one aggregation query which is MAX in first query and also in the second. Can you please explain?

[@techsapphire]

it is duplicate aggregation, not double aggregation. Kindly re refer video again

[@mallikarjuna9209]

to the point. Thank you sir!!!!!

[@techsapphire]

Glad it helped

[@shreyagupta582]

How to set statistics io,time on in mysql

[@techsapphire]

You have to use analyze in mysql

[@krishnakumargupta741]

thx you sir very nice video

[@techsapphire]

Most welcome

[@rajeshchittiprolu5281]

short and sweet. Well explained brother. Would you mind sending me the presentation.

[@techsapphire]

Kindly share your email

[@Fairplay2015]

Great 🙏🏼