Re: performance question

The id=27, on TRN it retuns 0 while it returns 31,967 rows on QA is understandable, cause on TRN it failed and it never reached that far.

Alvaro Jose Fernandez wrote:

> Hi Joan and all,
>
> What it's puzzling me is the output of id=27, the iff on
> PS0PERSONAL_DATA . On QA returns 31,967 , vs. 0 on TRN.
>
> stats for PS_EMPLOYMENT are the same on both (including indexes)????
>
> regards,
>
> alvaro
>
>
> (QA:
> STAT #1 id=27 cnt=0 pid=13 pos=2 obj=64184 op='INDEX FAST FULL SCAN
> PS0PERSONAL_DATA (cr=0 pr=0 pw=0 time=0 us)'
> )
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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