Suppose you want to remove the Optimizer Preference you set on the schema, table, or database, then the below procedure can be used to do that How to delete table level Optimizer preference The DBMS_STATS.DELETE_TABLE_PREFS procedure is used to delete the statistics preferences of the specified table in the specified schema. Example exec DBMS_STATS.DELETE_TABLE_PREFS ( […]

The post How to Delete Optimizer Preference appeared first on Techgoeasy.