New Video: Optimizing SQL Queries

Hi, Community!  

Please find a new session recording from Global Summit 2017:

Optimizing SQL Queries

https://www.youtube.com/embed/nEKYDd2meDM
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

After watching this video, you will learn how to identify slow SQL queries and optimize them.

@Harry Tong demonstrates using query plan, Index Analyzer, runtime stats, etc., to identify slow SQL queries. And then shows how to make then faster using Tune Table, indices, %Parallel, SQL hints, and frozen plan, etc.

You will find additional resources here.

What is more? 

You are very welcome to join InterSystems Global Masters Advocacy Hub where you can also complete some Video challenges and many more other entertaining and informative challenges. 

Feel free to ask any questions about the video in the comments of this post.

Enjoy!