Home » SQL & PL/SQL » SQL & PL/SQL » Global Temporary Tables
Global Temporary Tables [message #36131] Wed, 07 November 2001 05:30 Go to next message
KAW
Messages: 8
Registered: February 2001
Junior Member
Does anyone knows if there is a performance gain by using Temporary Tables instead of regular tables? Just because temp tables truncate tables implicitly after each commit does not imply a performance gain. Do you agree? I do not see where the performance gain will come from , but some on my team seem to think that temp tables will provide a performance gain.

----------------------------------------------------------------------
Re: Global Temporary Tables [message #36135 is a reply to message #36131] Wed, 07 November 2001 07:02 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
On the plus side, GTTs generate a minimum amount of REDO (compared to regular tables), unless you are doing a lot of deleting.

One possible downside, depending on the amount of data you load into the GTT for your session, is that statistics cannot be generated on a GTT. There is a way around that though - export statistics from a regular table and import them for the GTT using DBMS_STATS.

----------------------------------------------------------------------
Previous Topic: Re: Multiple DBMS_SQL.DEFINE_COLUMN
Next Topic: running totals
Goto Forum:
  


Current Time: Fri May 27 23:30:58 CDT 2022