Re: Interview Question on Subqueries vs Regular joins

From: <>
Date: Mon, 11 Feb 2008 10:07:02 -0800 (PST)
Message-ID: <>

> 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