Using Foglight and SQL Optimizer you can identify poorly performing queries and rewrite them or generate a more efficient execution plan. First, use Performance Investigator to identify and select the query you wish to tune, i.e., by number of executions, IO, CPU time, etc. The video explains how to use SQL Optimizer for better query performance.
On this page of the site you can watch the video online SQL Optimization with a duration of hours minute second in good quality, which was uploaded by the user Quest 12 August 2020, share the link with friends and acquaintances, this video has already been watched 1,276 times on youtube and it was liked by 3 viewers. Enjoy your viewing!