With Clause

From: raja <dextersunil_at_gmail.com>
Date: Wed, 5 Nov 2008 02:05:17 -0800 (PST)
Message-ID: <83f4a331-559c-4b01-aa32-7a7d857ab1f2@a29g2000pra.googlegroups.com>


I had a look at the usage of WITH Clause, where a repeated subquery can be replaced using WITH clause which reduces the complexity of the query.
Apart from this, i was not able to find anything regarding WITH Clause.

Please reply to my doubts on WITH Clause : 1. Apart from subquery replacement, what are the other usages of WITH Clause ?
2. Will the performance increase if we are using WITH Clause, instead of a subquery ?
3. What is the difference between WITH Clause and correlated subquery ?

Any other information regarding WITH Clause, please send them too.

Thanks in Advance.

With Regards,
Raja. Received on Wed Nov 05 2008 - 04:05:17 CST

Original text of this message