Re: Interview Question on Subqueries vs Regular joins
Date: Mon, 11 Feb 2008 15:55:04 -0800 (PST)
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