Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Installation Guide

Run Time Tab

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 image\I_Key_PlanChangedByIndexes.gif indicates that the query plan is changed by the proposed index. A key with a red exclamation mark image\I_Key_PlanChangedIndexNotApplied.gif 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 image\I_Key_PlanNoChange.gif 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:

  1. If the SQL was terminated by the termination criteria.

  2. If the SQL was run more than once.

  3. If a database error occurred.

Privileges

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

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating