Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it allowed to drop histograms on sys tables

Nenad NoveljicNov 27 2020 — edited Nov 27 2020

I'd like to drop a histogram on WRI$_OPTSTAT_SYNOPSIS_HEAD$ to get a better execution plan.
Further, I'd like to set it as a table preference not to create a histogram on this table any more.
I'm I allowed to do that?
Best regards,
Nenad

This post has been answered by Jonathan Lewis on Nov 28 2020
Jump to Answer
Comments
Post Details
Added on Nov 27 2020
2 comments
173 views