Re: SQL performance in prod

Remember that E-Rows is per execution, so you’ll need to multiply it by executions (or starts) to compare it against A-Rows

On Mon, 23 Jul 2018 at 20:46, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

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

--
http://www.freelists.org/webpage/oracle-l