Re: SQL performance in prod

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.
>

-- 
Mladen Gogala Database Consultant Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l