SQL Advisor

The SQL Advisor finds and presents opportunities for fine-tuning performance.

It uses a comprehensive set of warnings, alerts, and recommendations to convey this information. The SQL Advisor can also issue guidelines, notes, and other informational messages to assist you in understanding the logic behind certain design decisions and tuning choices. All advice is integrated into the Explain report. You control how much information is generated.