Page History
...
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 DB Optimizer 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 Tab.
Scroll pdf ignore |
---|
Automate SQL tuning and profiling with DB Optimizer. Learn more > > |