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.