Forum Stats

  • 3,741,293 Users
  • 2,248,405 Discussions
  • 7,861,728 Comments

Discussions

Is it allowed to drop histograms on sys tables

Nenad Noveljic
Nenad Noveljic Member Posts: 7 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

Sign In or Register to comment.