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