Optimizing SQL Queries

Published: 21 February 2018
on channel: InterSystems Developers
1,377
5

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: Harry Tong

See additional resources: https://learning.intersystems.com/cou...
You can discuss all the details and ask any questions about this video on the dedicated post on Developer Community. Here it is: https://community.intersystems.com/po...


On this page of the site you can watch the video online Optimizing SQL Queries with a duration of hours minute second in good quality, which was uploaded by the user InterSystems Developers 21 February 2018, share the link with friends and acquaintances, this video has already been watched 1,377 times on youtube and it was liked by 5 viewers. Enjoy your viewing!