Re: mysterious unnesting

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


>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.

See the Stephane's post how to get rid of both join and the filter!


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


Other related posts: