Re: Optimization question: Unrolling subquery into IN clause

From: HansP <Hans-Peter.Sloot_at_atosorigin.com>
Date: Wed, 21 Oct 2009 02:07:08 -0700 (PDT)
Message-ID: <8576a326-9db6-4f28-84b6-5e37e4995d22_at_m20g2000vbp.googlegroups.com>



On Oct 20, 4:01 pm, Wolfram Roesler <w..._at_spam.la> wrote:
> HansP <Hans-Peter.Sl..._at_atosorigin.com> wrote innews:6be649bd-ac4b-4b69-b021-7085e0f75f9c_at_s6g2000vbp.googlegroups.com:
>
> > SELECT tab1.several_columns
> > FROM tab1, tab2
> > WHERE tab.col1='Value'
> > and tab2.col3='Something'
> > and tab1.col2=tab2.key
>
> That makes no difference, it's the same execution plan and takes
> just as long as the subquery.
>
> Thanks for your help
> W. Rösler

Hi Wolfram,

I think the best option is to generate a 10053 trace file and see why it is using the hash join.

Regards HansP Received on Wed Oct 21 2009 - 04:07:08 CDT

Original text of this message