Re: mysterious unnesting

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Wed, 12 Jan 2005 23:38:10 +0100
Message-ID: <009101c4f8f7$672f9a40$3c02a8c0@JARAWIN>

Hi,

>Step 4 and 5 are hash joined resulting in one data set on which oracle
>does a sort aggregate

. to get the min(rowid)

>What I am not able to understand is the filter in id 1.
. It suppress the rows that doesn't match the filter condition, i.e. ("A".ROWID=MIN("B".ROWID)) See the Stephane's post how to get rid of both join and the filter!

Regards

Jaromir D.B. Nemec

Original Message ----- From: "amit poddar" <amit.poddar_at_yale.edu> To: <oracle-l_at_freelists.org> Sent: Wednesday, January 12, 2005 9:51 PM Subject: mysterious unnesting

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 12 2005 - 16:38:46 CST