Re: Ramming two SQL queries together.....

From: joel garry <>
Date: Fri, 28 May 2010 10:23:33 -0700 (PDT)
Message-ID: <>

On May 28, 12:18 am, "" <> wrote:
> Thankyou both gentlemen. I appreciate the feedback you have given me.
> I am not an Oracle expert so I was not sure what the best approach
> was. I will set both up and see which runs faster (I am guessing the
> inline due to the way correlated subqueries run).
> I thank you both very much.
> Cheers
> The Frog

I'm wondering about how you think correlated subqueries run. See

If you haven't already, get Jonathan's book about the optimizer. See this example:


-- is bogus.
Received on Fri May 28 2010 - 12:23:33 CDT

Original text of this message