Re: mysterious unnesting

  • From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 Jan 2005 23:38:10 +0100

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@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, January 12, 2005 9:51 PM
Subject: mysterious unnesting




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

Other related posts: