Re: Using temporary tables for query results
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