Re: performance question
- From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
- To: alvaro.fernandez@xxxxxxxxx
- Date: Mon, 10 Sep 2007 13:19:51 -0400
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
- References:
- RE: performance question
- From: Alvaro Jose Fernandez
Other related posts:
- » performance question
- » Re: performance question
- » RE: performance question
- » Re: performance question
- » Re: performance question
- » Re: performance question
- » Re: performance question
- » RE: performance question
- » Re: performance question
- » RE: performance question
- » Re: performance question
- » RE: performance question
- » RE: performance question
- » Re: performance question
- » RE: performance question
- » RE: performance question
- » Re: performance question
- » RE: performance question
- » Re: performance question
- » RE: performance question
- » performance question - Joan Hsieh
- » RE: performance question - Stephens, Chris
- » RE: performance question - SHEEHAN, JEREMY
- » Re: performance question - Karl Arao
- » Re: performance question - Ron Crisco
- » Re: performance question - Joan Hsieh
- » Re: performance question - Joan Hsieh
- » Re: performance question - Stefano Cislaghi
- » Re: performance question - Joan Hsieh
- » RE: performance question - Ojha, Ajeet (GE Healthcare, consultant)
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
- RE: performance question
- From: Alvaro Jose Fernandez