Re: Ramming two SQL queries together.....
From: joel garry <joel-garry_at_home.com>
Date: Fri, 28 May 2010 10:23:33 -0700 (PDT)
Message-ID: <da4f048e-6a1b-49ca-9b2a-fc283644861a_at_k25g2000prh.googlegroups.com>
On May 28, 12:18 am, "Mr.Frog.to...._at_googlemail.com" <mr.frog.to...._at_googlemail.com> 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
Date: Fri, 28 May 2010 10:23:33 -0700 (PDT)
Message-ID: <da4f048e-6a1b-49ca-9b2a-fc283644861a_at_k25g2000prh.googlegroups.com>
On May 28, 12:18 am, "Mr.Frog.to...._at_googlemail.com" <mr.frog.to...._at_googlemail.com> 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 http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries008.htm http://jonathanlewis.wordpress.com/2007/03/08/transformation-and-optimisation/
If you haven't already, get Jonathan's book about the optimizer. See this example: http://jonathanlewis.wordpress.com/2006/11/06/filter-subqueries/
jg
-- _at_home.com is bogus. http://www.networkworld.com/news/2010/052710-alleged-100m-scareware-sellers-facing.htmlReceived on Fri May 28 2010 - 12:23:33 CDT