Page History
...
The color-coded Index Analysis feature highlights missing indexes as well as shows which indexes are used and which are not used in the default execution path. The Index Analysis feature highlights issues where the database optimizer might not be using the preferred indexes. SQL Query Tuner also DB Optimizer also lists indexes on the tables that do not have fields in the WHERE clause helping the designer to see if adding an additional predicate in the WHERE clause might make use of an existing index.
...
- 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 recommendationsDB Optimizer 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 Platformplatform-Specific Featuresspecific features. |
| Info |
|---|
The text, diagram, and analysis sections can be resized or expanded to take up the whole page. |
...
| 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 DB Optimizer recommends that you create this index. |
| This index exists on the table but not usable in this query as it is written. |
...
For more information on using the Analysis tab, see Using the Analysis Tabtab.
| Scroll pdf ignore |
|---|
Automate SQL tuning and profiling with DB Optimizer. Learn more > > |