Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: performance question

Re: performance question

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Mon, 10 Sep 2007 13:19:51 -0400
Message-ID: <46E57CB7.3030808@tufts.edu>


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
Received on Mon Sep 10 2007 - 12:19:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US