Deactivating Zero-Row SQL Commands

Use this procedure to deactivate SQL commands that do not affect any data.

To deactivate zero-row SQL commands

1. Click the Deactivate 0-Row SQLs tab in Upgrade Tuner.

   The Deactivate 0-Row SQLs screen appears.

2. Click the Net Cost column head.

   This sorts the entries so that the longest running SQL commands appear first. If they do not, click the column head again. Commands deactivated in previous Upgrade Tuner sessions display at the end of the list.

3. Click in a row to display a command that returned zero rows.

4. Carefully evaluate whether you need this command for your upgrade.

5. Write down the net cost of the command.

   You can use a spreadsheet to keep track of net cost changes, if you prefer.

6. To deactivate the command, click in the check box in the Inactive column.

   The following occurs:

   • A check mark displays indicating the command is inactive.

   • The word Changed appears next to the check mark to indicate the change was made in this session.

   • The time displayed in the Net Cost column changes to Not applicable.

   • When you save and exit, Upgrade Tuner inactivates the command in the SQL file.

   • The next time you start Upgrade Tuner, a check mark displays in the Inactive column for the command, but the word Changed does not.