Global Temporary Tables [message #36131] |
Wed, 07 November 2001 05:30 |
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 |
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.
----------------------------------------------------------------------
|
|
|