This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

Is it allowed to drop histograms on sys tables

Nenad Noveljic
Nenad Noveljic Member Posts: 11 Blue Ribbon
edited Nov 27, 2020 10:59PM in General Database Discussions

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

Best Answer

Answers