Database » Ask Tom MOST RECENT ARTICLES » WITH Clause vs global temporary tables

Feeds

15142 items (92 unread) in 26 feeds

Database (92 unread)

• DBA's notes (6 unread)
• $Pete Finnigan's Oracle security weblog (1 unread)
• Ask Tom MOST RECENT ARTICLES (38 unread)
• Databases News (3 unread)
• DBAzine.com - Oracle Articles Archive
• Eddie Awad's Blog (3 unread)
• FeuerThoughts (1 unread)
• Mark Rittman's Oracle Weblog
• MR. ED's blog
• MySQL Performance Blog (9 unread)
• Niall's Oracle Pages
• OraBlogs
• Oracle + Open Source
• Oracle HTML DB Studio Recent Additions
• Oracle Security Alerts
• Oracle Software Downloads
• Oracle Technology News
• Oracle's OTN TechCasts (2 unread)
• Orawin.Info
• OTN TechBlog
• OTN/DBA
• Published Security Alerts
• The Dizwell Blog
• The Tom Kyte Blog (3 unread)
• TheServerSide.com (26 unread)
• Upcoming Security Alerts

Ask Tom MOST RECENT ARTICLES

• September 23, 2008
• 

  WITH Clause vs global temporary tables

  Fetched: September 22nd, 2008, 8:53am PDT

  Tags:    [edit]

  Hi Tom, Can you tell me why is the WITH clause faster than using GTT tables in this situation? ---- WITH clause with with_sere as (select /*+ parallel (dein,8) full(dein) */ dein.inte_no fr...