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!

[@radha040]

Very informative and core knowledge for every level of SQL developer. Thank you

[@techsapphire]

Glad it was helpful!

[@dbamentorparag]

I am in Adelaide Australia and watching your video

[@techsapphire]

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

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

[@prabasmessi]

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

[@techsapphire]

Glad it was helpful!

[@Penjarlamahesh]

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

[@techsapphire]

Glad to hear that

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

[@karthikkeyan4460]

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

[@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

[@satheeshkandukurii5251]

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

[@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

[@jagjeetrathore9122]

i watched many videos , found this one awesome for beginners

[@techsapphire]

Thank you for your feedback.

[@maruthibachu8854]

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

[@techsapphire]

Thank you, I will

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

[@kuldeepsharma3822]

Bro ek no.. explained very well ...

[@DIZS_PVT_LTD]

Very Good Lecture gives me so much clarity.

[@techsapphire]

Glad it was helpful!

[@kaushikkrishnan5828]

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

[@techsapphire]

Glad it was helpful!

[@shreyadutta5817]

Very informative... Brilliantly explained

[@techsapphire]

Glad you liked it

[@DineshArya-n9l]

Amazing tutorial on query tuning... thanks a lot

[@dishantrana341]

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

[@techsapphire]

Glad you find it helpful

[@ashwineemehta9449]

I went though this video and found it very useful.

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

[@jaredlising-simplybrewedph]

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

[@techsapphire]

Glad it was helpful!

[@parixitsinhchauhan5186]

nicely explained every topic. Good Video

[@techsapphire]

Glad you liked it

[@calvinball1]

This is an astoundingly good video

[@techsapphire]

I'm glad you like it

[@vijayalakshmibadigeru4479]

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

[@techsapphire]

Glad you liked it

[@Sk8erBhai]

Great video, brother. Have learnt so much so quick

[@techsapphire]

Glad to hear it!

[@deepak21000]

Excellent performance tuning tutorial

[@techsapphire]

Glad you liked it!

[@saurabhashok2857]

Simply outstanding explanation. Thanks!

[@techsapphire]

Glad it was helpful!

[@saikumarramisetty]

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

[@techsapphire]

Glad it helped!

[@gokuls3000]

this is best video for performance tuning

[@techsapphire]

Thank you for positive feedback

[@priyankasarkar6600]

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

[@techsapphire]

Sure thing! Keep learning :)

[@devarakondasankararao3802]

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

[@techsapphire]

Glad it was helpful!

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

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

[@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]

[@mahaalsalman2323]

Thank you for good teaching you explained it very clearly

[@techsapphire]

Glad it was helpful!

[@darrylw99]

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

[@ganeshvarma370]

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

[@techsapphire]

Thanks, will do!

[@ManishPurohit-gl6lq]

It's a brilliant explanation.

[@techsapphire]

Glad you liked it

[@DD-dp6ge]

Amazing, very well explained, thanks!

[@techsapphire]

Glad it was helpful!

[@nandiniguntur4509]

Good job. The explanation is very succint

[@techsapphire]

Glad it was helpful!

[@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

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

[@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 ❤❤❤❤

[@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

[@haribabunaiduyasanoor5233]

Excellent session Sir!!

[@techsapphire]

Glad you liked it!

[@pravaspatra3849]

Its very helpful. Please share more videos

[@ArundheerajYellutla]

Thanks for your detail explanation

[@techsapphire]

Glad it was helpful!

[@ravindark646]

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

[@techsapphire]

Glad it was helpful!

[@srikanthkurra9513]

Thanks for the complete explanation

[@techsapphire]

Glad it was helpful!

[@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

[@ashutoshsrivastava2275]

Thank you very much for all your effort.

[@techsapphire]

Always welcome

[@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

[@NareshDama-qv3iu]

Very useful information.. thank you so much!!

[@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

[@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

[@rainmaker168]

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

[@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

[@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

[@P5toraskar1986]

Superb information.

[@techsapphire]

Thanks a lot

[@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]

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

[@anuragjains2195]

Nicely explained. Thank you very much!

[@techsapphire]

Thank you for your feedback.

[@ArdianUmam]

Thanks so much for the great video! Where can I get the slide and the script?

[@techsapphire]

Kindly share your email for it.

[@ArdianUmam]

techsapphire : [e-mail]. Thanks in advance.

[@SN-zr3rf]

Sir, I need this script and requesting you to forward [e-mail]

[@codearabawy]

That's awesome, thank you very much!

[@techsapphire]

You're very welcome!

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

[@nilamsherkar]

can i get this database to practice the questions

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

[@niha46]

nice explanation, very helpful.

[@techsapphire]

Glad it was helpful!

[@SandeepYadav-vm5hd]

Amazing Video Very useful !!!

[@techsapphire]

Glad it was helpful!

[@craghava5834]

excellent..but the only thing is that your voice breaking in the middle

[@techsapphire]

Sorry for that

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

[@Latif127]

Very helpful tutorial, thank you.

[@techsapphire]

Glad it was helpful!

[@ranjitreddy6316]

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

[@techsapphire]

Glad it was helpful!

[@karanrewari6482]

amazing video!! very helpful, thanks!

[@techsapphire]

Glad you found it helpful.

[@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

[@gabrielegbenya7479]

Hi Yogesh! Thank you for the lecture; it was very educative, can you please share me the script and ppt presentation . Also do we need to SET STATISTICS IO OFF after the query optimization project? Thank you.

[@techsapphire]

Sure, please share your email. You don't need to set it off as it is session level. So moment you close query window, it is gone

[@krishanajangid1763]

Hi yogesh, thanks you for the lecture. It was very educative. Please share the ppt, quries, and database back used in the video. My email id is [e-mail].

[@katabathinadamodar732]

@@techsapphire have you send to [e-mail] also...thanks

[@ravindrabisht7520]

@@katabathinadamodar732 if u got script, would u, please share with me?

[@ravindrabisht7520]

@@krishanajangid1763 if u got script, would u, please share with me?

[@gomathyelango5574]

Is this query tuning applicable to oracle database as well?

[@techsapphire]

yes query mistakes are common

[@hearttouchingsoul]

Please share download database link, which you are using in this

[@pravaspatra3849]

please share the database file and the script used for performance optimization.

[@techsapphire]

please share your email

[@manikandanp3128]

Could you please share your database file and script into my mail-id: [e-mail]

[@kjkanishk7575]

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

[@techsapphire]

Glad you liked it!

[@yogisawant9891]

Nice video. Thank you sir

[@techsapphire]

Most welcome

[@mallikarjuna9209]

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

[@techsapphire]

Glad it helped

[@dishaverma3522]

Thanks allot it's really helpful

[@techsapphire]

You're welcome!

[@yashpatil2536]

Amazing Thank you so much!

[@techsapphire]

Glad you like it!

[@labs_with_om]

Awesome, just below excellent,

[@techsapphire]

Thank you so much 😀

[@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

[@shivamtewari309]

Is there any sql formatter for redshift?

[@techsapphire]

use dbeaver, it has internal formatter for every database

[@shreyagupta582]

How to set statistics io,time on in mysql

[@techsapphire]

You have to use analyze in mysql

[@sangeetatulsiyan314]

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

[@techsapphire]

mail me at [e-mail]

[@aloksinha6342]

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

[@techsapphire]

Please share your email

[@avirajankitjain256]

from where i can get the data ?

[@techsapphire]

kindly mail me at [e-mail]

[@Jogukrish]

outstanding Sir

[@techsapphire]

Many thanks