Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

For some reason, the new statistics collected by the job results in sub-optimal plan. How do I go back to the old statistics?

0
Posted

For some reason, the new statistics collected by the job results in sub-optimal plan. How do I go back to the old statistics?

0

You can use the restore procedures of dbms_stats package to restore statistics as of a specific time.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123