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
]]
Sent: Tuesday, April 09, 2002 4:45 PM
To: '[EMAIL PROTECTED]'; Koivu, Lisa
Subject:RE: Explain: In List Iterator
Thanks, Lisa!
I have not tkprof'd it. I'm beginning to wonder if the thing will ever
complete.
I think I might instead suggest ever-so-gently to the developer
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 List Iterator
Thanks, Lisa!
I have not tkprof'd it. I'm
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
Subject: RE: Explain: In List Iterator
Thanks
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 List Iterator
Thanks, Lisa!
I have not tkprof'd
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
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 use of that table in this query or am I missing something