The Run Time tab in the Index Advisor window displays the run time information for the SQL statement using the alternative indexes. The values are filled in after the Show Plan, Batch Run, Run for First Record, or Run for All Records functions are executed.
For Index candidates proposed by the Index Advisor, an icon is added in the far left column to indicate if the proposed index is used in the query plan. A key with a green checkmark indicates that the query plan is changed by the proposed index. A key with a red exclamation mark
indicates that the key plan changed, but that the proposed index was not used by the new query plan. A key with a red x
indicates that the query plan is not changed by the addition of the proposed index.
Item | Description |
Scenario Name |
The index advising process numbers the SQL alternatives. |
Estimated I/O cost |
This is a cost estimation calculated by Adaptive Server for the query plan. |
Actual I/O Cost (All Records and First Record) |
This is the Actual I/O Cost of the SQL statement after it was executed in the Batch Run or the Run Time functions. |
Elapsed Time (All Records and First Record) |
This is the run time calculated from the clock start and finish times for the SQL statement. |
Times of Improvement (All Records and First Record) |
If the original SQL statement run time is available, this indicates how much faster the SQL statement is under the alternative index(es) than it is under the original index(es). |
Records (All Records and First Record) |
This is the number of records processed by the SQL statement. |
Remarks |
Information from the Batch Run is included in this column. It includes:
|
Estimated I/O cost, All Records Actual I/O Cost and First Record Actual I/O Cost are not available for logon users without sa_role privileges or with the "allow resource limits" configuration parameter turned off for the Adaptive Server. To retrieve the Estimated I/O cost, All Records Actual I/O Cost and First Record Actual I/O Cost estimations, you should either grant yourself sa_role, logon as another user with sa_role privileges, or turn on the "allow resource limits" parameter:
sp_configure "allow resource limits", 1
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center