Page History
...
- Statement selector, if there are multiple statements in the tuning set. Here you can select the statement and the generated case you want to analyze.
- Statement text for selected statement.
- Graphical diagram of the SQL statement.
- Index analysis, statistics, and settings relating to the SQL statement and referenced elements.
- Description of the selected index, including the reasoning behind SQL Query Tuner recommendations.
| Info |
|---|
Tabs are platform-specific. For example, against Oracle data sources, Table Statistics, Column Statistics And Histograms, and Outlines tabs are available. For more information, see Using Platform-Specific Features. |
| Info |
The text, diagram, and analysis sections can be resized or expanded to take up the whole page. |
The Analysis tab suggests missing indexes, indicates which indexes are used in the execution path and lists all indexes that exist on all the tables in the query. Indexes on the table are listed on the Analysis tab and color coded as follows:
| Text Color | Interpretation |
|---|---|
| Index is used in the query |
| Index is usable but not used in the current execution path. |
| This index is missing. SQL Query Tuner recommends that you create this index. |
| This index exists on the table but not usable in this query as it is written. |
In the Collect and Create Indexes table, orange-highlighted entries indicate missing indexes that SQL Query Tuner recommends be created to improve performance. Clicking on that index, displays text to the right outlining the rationale behind this recommendation.
For more information on using the Analysis tab, see Using the Analysis Tabtab.