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)') -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l