RE: performance question
- From: "Alvaro Jose Fernandez" <alvaro.fernandez@xxxxxxxxx>
- To: "Joan Hsieh" <joan.hsieh@xxxxxxxxx>
- Date: Mon, 10 Sep 2007 16:59:36 +0200
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
Other related posts:
