Please find a new session recording from Global Summit 2017:
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.