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

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

join update and nvl

Transparent Data encryption in 10g release 2

Some of the DBMS_JOB jobs remain in suspended stage

Oracle 9i installation requirement on XP

About query performance in a Trigger...

how to deal with semi-technical person

Simple SQL

Reg: Rownum

NULL or Space

Is RAC the logical choice for a modern database system?

WITH Clause vs global temporary tables

Comments

Post Your Comment:

Subscribe via RSS

Oracle FAQ

Sponsored Links