FAQ

WITH Clause vs global temporary tables

Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

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...

Read More...

Sponsored Links

Read Next: Oracle Data pump(DBMS_DATAPUMP)

Comments

Subscribe via RSS

Subscribe to GeekArticles.com by Email

Enter your email address:

Subscribe in a reader

Oracle FAQ

Synchronize data from remote location
Oracle Fundamentals
How to connect SQLPlus without tnsnames.ora
Best Practices for App Server Keep Alive
bind variables in triggers
how to avoid outer joins
One 900 column table versus ten 90 column tables.
Does select generate undo ?
Performance Question
Help analyze statspack report

WITH Clause vs global temporary tables

Comments

Post Your Comment:

Subscribe via RSS

Oracle FAQ

Sponsored Links