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 👍👍👍👍
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.
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 🙌🏽
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..
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 ❤❤❤❤
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
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.
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.
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.
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.
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?
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?
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.
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..
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.
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?
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 👍👍👍👍
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.
@@techsapphire can we have your contact number or whatsapp number/ email id
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 🙌🏽
This is the best class in terms of SQL Performance Tuning. Thank You..
Glad you like it!
I asked to optimize query by product owner after that start watching your video, it help me a lot. Thank you so much!!
Glad it helped!
I am in Adelaide Australia and watching your video
awesome :) nice to see you here in comment as well.
Thank you so much for sharing the knowledge. Best explanation for query optimization i have seen till now.
Glad it was helpful!
Really this is one of the BEST video ever, so easy to understand. Very very very helpful. Thanks a lot for this brilliant one.
Glad it was helpful!
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..
Glad it was helpful!
Wonderful and Excellent Knowledge based in-depth Performance Tuning Video
Glad you liked it!
Excellent teaching skill, your explanation is very clear and very easy to understand ❤
Glad to hear that
Extremely helpful. Searched a lot for help and video stands out to be unique. Thank you. :-)
Glad you find it good
Thanks! Thanks a lot Yogesh for your time and efforts in this particular video. This helped me a lot..
Glad it helped
Excellent ! outstanding video., most of the concept were unknown.., really helped a lot., thanks a lot Bhai.., pls create more stuff like this..,
Thank you, I will
Really its awesome.. Its helped lot and easy to understand.. please make more videos. thank you
Thank you, I will
Very Good Lecture gives me so much clarity.
Glad it was helpful!
Really awesome...pls do more videos on performance tuning
i watched many videos , found this one awesome for beginners
Thank you for your feedback.
Amazing tutorial on query tuning... thanks a lot
Thank you so much for such detailed explanation! Appreciate it so much! 😊
Glad it was helpful!
Very informative... Brilliantly explained
Glad you liked it
Insanely good video. Helped for my DE interview
Glad it helped! I provide training as well.
Thank you for this video. This is very helpful and it helps me to understand how the execution plan work. I need a scripts.
You can find the scripts in the video description.
Amazing, super helpful to get a direction on how to go about optimizing queries
Glad it was helpful!
This is just amazing, going to share with all mates.
Glad you find it helpful
Very excellent video .Thank you so much for this explanation.
Glad it was helpful!
I went though this video and found it very useful.
Glad it was helpful!
nicely explained every topic. Good Video
Glad you liked it
Great video, brother. Have learnt so much so quick
Glad to hear it!
Really great video... We look forward to learn more ✌️
Glad you liked it
Excellent performance tuning tutorial
Glad you liked it!
Good job. The explanation is very succint
Glad it was helpful!
this is best video for performance tuning
Thank you for positive feedback
Bro ek no.. explained very well ...
Nice to hear that, I will be uploading more videos on similar topics.
Timstamps for various topics covered..
18:21 Hashmatch
23:54 KeyLookup
Learned So much, Keep doing more videos. Respect++
Thanks, will do!
very explained Sir, Thank you for the video.
Glad it helped
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 ❤❤❤❤
Thank you so much for the awesome video, I got a clear idea about the Performance tuning
Glad it helped!
Amazing, very well explained, thanks!
Glad it was helpful!
Simply outstanding explanation. Thanks!
Glad it was helpful!
Nice explanation and got clear Idea on the such things. Thanks :)
Glad it was helpful!
Thank you for good teaching you explained it very clearly
Glad it was helpful!
Excellent session Sir!!
Glad you liked it!
Thanks for your detail explanation
Glad it was helpful!
Awesome Sir..:) On point tutorial! Please make more videos on triggers, cluster, cursor.. Thanks in advance..:)
Sure thing! Keep learning :)
Thanks for the complete explanation
Glad it was helpful!
This is an astoundingly good video
I'm glad you like it
It's a brilliant explanation.
Glad you liked it
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
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.
Its very helpful. Please share more videos
Superb information.
Thanks a lot
Thank you very much for all your effort.
Always welcome
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.
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 yogesh.mehla@gmail.com
Great content, as you mentioned it’s one out of two parts, could you please comment the second video link here
Post this video, there are many videos on how to capture expensive queries etc. You can check
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.
where did you get the extra tables in your Northwind, mine only has 9 tables
Awesome, just below excellent,
Thank you so much 😀
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.
this is realy good picture of optimization .. also please add sql profiler in terms of optmization
Thank you for your feedback. I will add session on sql profiler too.
nice explanation, very helpful.
Glad it was helpful!
Nice video. Thank you sir
Most welcome
Nicely explained. Thank you very much!
Thank you for your feedback.
Amazing Video Very useful !!!
Glad it was helpful!
That's awesome, thank you very much!
You're very welcome!
This was such a good video I’m shocked ahahaha! Do you have any more optimisation tips and how diagnosing slow queries?
Yes I do! Alot are on my channel kindly check, I also provide commercial sessions
Very useful information.. thank you so much!!
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
single query will not have major impact, its important to have most of the queries to be optimized to ensure good performance
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.
Yes, correct. Performance optimization using query tuning is mainly job of SQL Dev not DBA
Very helpful tutorial, thank you.
Glad it was helpful!
Amazing Thank you so much!
Glad you like it!
amazing video!! very helpful, thanks!
Glad you found it helpful.
Is this query tuning applicable to oracle database as well?
yes query mistakes are common
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?
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
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?
follow link in description for database backup
@@techsapphire Where is the link?
Thanks allot it's really helpful
You're welcome!
Thanks Much For this video! Really appreciate it! :)
Glad it was helpful!
While
optimizing T-SQL Queries, in the logical query execution plan, what are the top
3 operators which we should eliminate / optimize?
Lazy spool one and only other are more dependent on situation
Hash Join is not always bad, especially dealing with very large tables.
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.
@@techsapphire agree
outstanding Sir
Many thanks
thanks ... :) ... really great presentation.
Glad you liked it!
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..
Is your research only SQL Server or other databases as well?
Great tutorial! I learned a lot!
Glad it was helpful!
nice video sir
Thanks and welcome
I have a table with more than 100 columns, so how many indexes can create for a single table?
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.
Very very nice
Thanks a lot
Thank you, can you please share this ppt and example queries.
mail me at yogesh.mehla@gmail.com
good explanation..
Thanks and welcome
Thanks.
Please share the init db script for Student Table.
Very nice explanation.One of the best.Could you please share the scripts also..
Please share your email
Hello Yogesh sir, Can we get the ppt, DB and the scripts ? Thanks. I learned a lot from this video.
Kindly share your email
@@techsapphire i sent you a mail
can i get this database to practice the questions
Hi, I am having issue with stored procedure as it is taking huge time.. Can you please help me
I provide commercial support
Hi Yogesh, at one point you mention "group before, not after" what do yuo mean by that?
I am confused about reference, if you want to discuss in detail, kindly reach me on skype yogesh.mehla@live.com
from where i can get the data ?
kindly mail me at yogesh.mehla@gmail.com
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?
it is duplicate aggregation, not double aggregation. Kindly re refer video again
good information...
Thanks
to the point. Thank you sir!!!!!
Glad it helped
How to set statistics io,time on in mysql
You have to use analyze in mysql
thx you sir very nice video
Most welcome
short and sweet. Well explained brother. Would you mind sending me the presentation.
Kindly share your email
Great 🙏🏼