Re: Interview Question on Subqueries vs Regular joins

From: <leonard.reinstein_at_gmail.com>
Date: Mon, 11 Feb 2008 10:07:02 -0800 (PST)
Message-ID: <e21e061a-eae7-418d-bf9b-47afed7194ac@s8g2000prg.googlegroups.com>


> 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".
>

Understood. So what would be the general guidelines for a developer to use "regular" joins as opposed to subqueries? Or does it simply a matter of coding preference and won't matter from design and performance perspective? Received on Mon Feb 11 2008 - 12:07:02 CST

Original text of this message