Hello All,
In Oracle 19c, I am doing some tests for E-Rows. However, E-Rows cannot be updated unless I change the query. What should I do in order to see updated E-Rows data.
For ex. I deliberately insert skew data and get statistics without histogram. I check execution plan via dbms_xplan.display_cursor Then, I get statistics with histogram and check the execution plan again but E-Rows remain same for the same query.
On the other hand, if I use EXPLAIN PLAN FOR or AUTOTRACE, E-Rows changes. It is because a new plan is inserted to PLAN_TABLE everytime. Why DBMS_XPLAN.DISPLAY_CURSOR is not updated?
Thanks in advance.