Re: Temporary tables, performance advantages?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 19 Nov 2001 18:23:35 -0800
Message-ID: <9tcer701huk@drn.newsguy.com>

In article <Z5iK7.38695$Ze5.20979282_at_news1.rdc1.md.home.com>, "Reidel says...
>
>Are there any performance advantages to be had by using GLOBAL TEMPORARY
>tables?

As opposed to using a permanent table to do the same? Yes.

o little redo generated
o little rollback (which accounts for the little redo) o automatically cleans itself out without redo/rollback (unlike a permanent table)
o automatically cleans itself out (unlike a perm. table)

As opposed to doing as much as you can in a single query? usually not...

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Nov 19 2001 - 20:23:35 CST