Re: sql tuning

Posted by ErmanArslansOracleBlog on Jul 30, 2018; 8:30am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/sql-tuning-tp6504p6509.html

you didn't copy and paste the whole output , I guess?
Ther should be some note in the bottom -> cardinality feedback used for this statement

E-Rows is the number of the expected rows.
The optimizer calcuates this E-rows  using the statistics in the data dictionary.

Probably, your second execution plan used the information from the first execution plan.
So , i think it is because the "cardinality/statistics feedback

Take a look -> https://blogs.oracle.com/optimizer/cardinality-feedback