Re: Optimization question: Unrolling subquery into IN clause

From: Wolfram Roesler <wr_at_spam.la>
Date: Tue, 20 Oct 2009 14:01:33 +0000 (UTC)
Message-ID: <Xns9CAAA3077DC64wrgrpde_at_news.albasani.net>

HansP <Hans-Peter.Sloot_at_atosorigin.com> wrote in news: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 Received on Tue Oct 20 2009 - 09:01:33 CDT