Issues with Optimizer_Features_Enable

[gandolf989]

Thanks for the inputs.

The rows are not deleting constantly based on date. Moreover this query is a Peoplesoft delievered process.

Perhaps you should try posting an explain plan, "set autotrace on" and "set timing on", and then run the query and delete statements and post the results.