Task: Identify slow SQL queries and optimize them.
Approach: Demonstrate using query plan, Index Analyzer, runtime stats, etc., to identify slow SQL queries. Then show how to make then faster using Tune Table, indices, %Parallel, SQL hints, and frozen plan, etc.
Presenter: Anton Umnikov
NOTE: You may experience an issue launching lab environments in some courses.
The launcher button for these courses may say "Checking for existing lab" indefinitely.
We are working to resolve this ASAP.
Questions? email online.training@intersystems.com
Having an issue with the learning site? Want to provide feedback on a course? Contact us by emailing online.training@intersystems.com.
Please include all relevant information, including the page or course you are having trouble with, and any necessary screenshots.