Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WITH clause verses an INLINE view

KevinFitzSep 15 2010 — edited Sep 23 2010
Hi,

I was wondering if someone could shed light on why/if a subquery defined using a WITH clause ( and referenced more than once by a containing statement ) is more efficient than defining it as an INLINE view?

regards,

Kevin.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2010
Added on Sep 15 2010
14 comments
12,621 views