Re: With Clause

Hello,

Ad 1 - I found WITH to be a workaround for what I think is Oracle BUG with some bit complex FULL OUTER JOIN statements that wouldn't work as subqueries but worked as expected with WITH Clause.

Regards,
 Jan

On Nov 5, 11:05 am, raja <dextersu..._at_gmail.com> wrote:
> Hi,
>
> I had a look at the usage of WITHClause, where a repeated subquery
> can be replaced using WITHclausewhich reduces the complexity of the
> query.
> Apart from this, i was not able to find anything regarding WITHClause.
>
> Please reply to my doubts on WITHClause:
> 1. Apart from subquery replacement, what are the other usages of WITHClause?
> 2. Will the performance increase if we are using WITHClause, instead
> of a subquery ?
> 3. What is the difference between WITHClauseand correlated
> subquery ?
>
> Any other information regarding WITHClause, please send them too.
>
> Thanks in Advance.
>
> With Regards,
> Raja.
Received on Thu Nov 06 2008 - 12:05:04 CST