Page History
...
The Analysis tab contains information about the statement or case, its full SQL code, a diagram of the SQL statement, and Index Analysis.
Additionally, for the Oracle and SQL Server platforms there are Table Statistics, Column Statistics and Histograms, and Outlines/Plan Guides tabs. For more information, see Using Platform- Specific Features.
Statement analysis is performed when you click Perform detail analysis on the Overview tab and then click Run Job or when you click the Analysis tab. In order to view and analyze statement statistics, select the tab (Index Analysis, Table Statistics, Column Statistics and Histograms, or Outline) and the statements whose statistics you want to analyze.
...
For more information, see Visual SQL Tuning.
| Anchor | ||||
|---|---|---|---|---|
|
...
index analysis recommendations
Once you have added tuning candidates to a tuning job, SQL Query Tuner can analyze the effectiveness of the indexes in the database and recommend the creation of new indexes where the new indexes can increase performance.
...