Viewing workload details

Use the Workload Details window to view the execution time for each SQL statement in the workload in timerons. The Current column shows the execution time for the statement with your current indexes. The Recommended column shows the execution time for the statement with the recommended indexes.

Fields and controls

Authorities and privileges



To view workload details:

  1. Open the WorkLoad Details window.

  2. To view a complete SQL statement, select a statement and click the View statement push button. The SQL Statement window opens.

  3. To view the access plan graph for a SQL statement, select a statement and click the Explain statement push button. The Access Plan Graph window opens. Press F1 or click the Help push button for instructions on how to use this window.

  4. Click Close to close the window and return to the Recommendations page of the Index SmartGuide.


Related information