Re: Interview Question on Subqueries vs Regular joins

On Feb 11, 9:48 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Feb 11, 11:44 am, leonard.reinst..._at_gmail.com wrote:
>
> > Hi!
>
> > I was asked the following question at a technical interview: when
> > would you use subqueries and when would you use regular joins (pros
> > and cons of each approach in terms of design and performance)?
>
> > I have read several articles on the subject but could not find a good
> > answer to this question.
>
> > Any help would be appreciated.
>
> > Thanks!
>
> This technical interview question does not make sense.  Oracle _may_
> automatically transform a subquery into an inline view, which then is
> joined to the rest of the query as a "regular join".

Perhaps the question was more to style than to how Oracle internally masticates the query.
-robert Received on Mon Feb 11 2008 - 17:55:04 CST