Re: Using temporary tables for query results

From: Tim X <timx_at_spamto.devnul.com>
Date: 14 Dec 2002 16:09:16 +1100
Message-ID: <87vg1xuqyr.fsf_at_tiger.rapttech.com.au>


drmiller100_at_hotmail.com (Doug Miller) writes:

>
> basically, there are no performance differences between using temp
> tables and "permanent" tables that get dropped. There might be a teeny
> bit of overhead involved, but in the order of less then one second
> difference in response time for a big query.
>

I don't think this is necessarily true, especially with Oracle. If you are using 8i or greater, then look at temporary global tables. These are more efficient than a 'normal/permanent' table because redo logs are not created for inserts/updates to the table - on a large enough table, this can be a big hit on performance. Also, the global temp table is put into a different tablespace which avoids fragmenting your main tablespace etc.

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!
Received on Sat Dec 14 2002 - 06:09:16 CET

Original text of this message