Displaying Zero-Row SQLs

You can view and sort zero-row SQLs in several ways:

• Default sort. The default sort order is the order in which the zero-row commands appear in the driver files. Any inactivated SQL commands, including those inactivated in previous sessions appear at the end of the list. The default sort order displays when you start Upgrade Tuner.

• Display items sorted by cost. To sort commands from longest-running time to shortest, click the Net Cost column head. To reverse the sort order, click Net Cost again. Commands inactivated prior to this session appear at the end of the list.

• Display commands activated or deactivated in the current session. Click the Inactive column head. Items display at the beginning of the list. The word Changed displays in the Inactive column for these items. Items that have been deactivated display check marks. Items that have been activated do not.

• Display commands inactivated in previous sessions. Click the Net Cost column head and scroll to the end of the list. Inactivated commands do not have a check mark in the Inactive column and do not display the word Changed.

• Display commands activated in previous sessions. The display of SQL commands does not provide a way to identify commands activated in a previous Upgrade Tuner session. When you activate a command, write down its SQL file name and SQL tag number so you can locate the command in future sessions.

• Display all the zero-row SQL commands in a file. Click the SQL File column head. This action sorts the file names alphabetically. To reverse the sort order, click the column head again.