Use /*+ GATHER_PLAN_STATISTICS */ hint and you will see E-Rows and
A-Rows in the plan. E-Rows are estimated rows, A-rows are actual rows.
The problem is where there is significant difference between the two.
Regards
On 7/18/2018 6:30 PM, V Raman wrote:
I am trying to figure out the cause(s). Assuming there is not much change in the DB, the first thing that comes to mind is statistics. Can the listers help with ideas? Thanks.