Date: Wed, 5 Nov 2008 02:05:17 -0800 (PST)
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
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
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.
Raja. Received on Wed Nov 05 2008 - 04:05:17 CST