Re: Unexpected Tkprof Row Count

> I would go back to the raw
> trace file and check to see if the stat lines are
> being output in the ID order. Possibly a few
> lines have been re-arranged in the plan - I have
> seen it happen (but only a couple of times) in the past.
>

It appears that in this case that the row count is correct for the SORT operation... See below:

PS_TM_PEFF_T_CONTR '
STAT #1 id=20 cnt=6220 pid=13 pos=2 obj=22902 op='TABLE ACCESS FULL PS_TM_PEFF_TWTCAL '
STAT #1 id=21 cnt=1176 pid=12 pos=2 obj=14440 op='TABLE ACCESS FULL PS_TM_PEFF_COEF '

STAT #1 id=22 cnt=2352 pid=11 pos=2 obj=0 op='VIEW PS_TM_PEFF_V_CCEH '
STAT #1 id=23 cnt=7314720 pid=22 pos=1 obj=0 op='SORT GROUP BY '
STAT #1 id=24 cnt=110312 pid=23 pos=1 obj=0 op='FILTER '
STAT #1 id=25 cnt=145807 pid=24 pos=1 obj=0 op='NESTED LOOPS OUTER '
STAT #1 id=26 cnt=110465 pid=25 pos=1 obj=22900 op='TABLE ACCESS BY