Re: Using temporary tables for query results

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!