get through
> to the developer without resorting to my curt type of "people skills"
>
> Post your tkprof, I am curious to see it.
>
> > -Original Message-
> > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 09, 2002 4:
I am curious to see it.
>
> > -Original Message-
> > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 09, 2002 4:45 PM
> > To: '[EMAIL PROTECTED]'; Koivu, Lisa
> > Subject:RE: Explain: In List Iterator
> >
There are two odd features I would pursue:
There is no join to the customer table and that
is why (I guess) you have a cartesian merge
join between CUSTOMER and everything else.
The second thing is that despite the inlist iterator,
Oracle thinks that the rest of the query will return
approximat
ROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, April 09, 2002 4:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Explain: In List Iterator
>
> Uh I'm just wondering about the customer table there... anything look
> odd about the
"Baker, Barbara" wrote:
>
> Hi, list.
> I'm trying to find out what's eating my system. I found the query, and
> explain'ed it. I've never seen an "in list iterator" before. Can anyone
> tell me what that is???
>
> Thanks!!
>
> Barb
>
> Execution Plan
> -
rt type of "people skills"
Post your tkprof, I am curious to see it.
> -Original Message-
> From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 4:45 PM
> To: '[EMAIL PROTECTED]'; Koivu, Lisa
> Subject: RE: Explain: In
loper without resorting to my curt type of "people skills"
Post your tkprof, I am curious to see it.
> -Original Message-
> From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 4:45 PM
> To: '[EMAIL PROTECTED]'; Koivu, Lisa
> Subj
> --
> From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 2:42 PM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Explain: In List Iterator
>
> Hi Barbara,
>
> I believe
The INLIST INTERATOR takes a result set, and "interates" over that
result set returning a result set that matches the values of the
IN predicate.
This is documented, quite well, in the Oracle9i Documentation.
-Original Message-
Sent: Tuesday, April 09, 2002 5:11 PM
To: Multiple recipien
Hi Barbara,
I believe 'in list iterator' is the way the optimizer is handling one of
your in () statements in your query. Beware in lists with a large number of
values in the set... as expansion of these in lists can create an incredibly
ugly OR'd query.Saw this once and gave it the no_expa
10 matches
Mail list logo