Page History
...
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 Platformplatform- Specific Featuresspecific 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 Tuningtuning.
Anchor | ||||
---|---|---|---|---|
|
...
index analysis recommendations
Once you have added tuning candidates to a tuning job, SQL Query Tuner DB Optimizer can analyze the effectiveness of the indexes in the database and recommend the creation of new indexes where the new indexes can increase performance.
In the Collect and create indexes table, any indexes SQL Query Tuner DB Optimizer recommends you create are marked in orange.
...
To run the index SQL and create the index on the selected database, click Execute.
Scroll pdf ignore |
---|
Automate SQL tuning and profiling with DB Optimizer. Learn more > > |