Deleting an optimization profile
You can remove an optimization profile that is no longer needed by deleting it from the SYSTOOLS.OPT_PROFILE table. When an optimization profile is referenced, it is compiled and cached in memory; therefore, if the original profile has already been used, you must also flush the deleted optimization profile from the optimization profile cache.
Procedure
To delete an optimization profile:
Results
Any subsequent reference to the optimization profile causes the optimizer to return SQL0437W with reason code 13.