The following situation is the trigger for deleting optimizing information:

• When you switch to tuning individual SQL statements separately

The following is the procedure for deleting optimizing information.

Procedure

1. Determine the table whose optimizing information you wish to delete.
   Determine the table whose optimizing information needs to be deleted.
   If you are tuning each SQL statement separately, the optimizing information of the tables accessed by that SQL statement becomes subject to deletion.
   
2. Delete the optimizing information.
   Use the pdgetcst command to delete the optimizing information.
   Command execution example:
   An execution example of the pdgetcst command for deleting the optimizing information of table USER1.T1 follows:
   

   pdgetcst -d -a USER1 -t T1