Re: Using temporary tables for query results

Tim X <timx_at_spamto.devnul.com> wrote in message news:<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
>
> I don't think this is necessarily true, especially with
> Oracle. If you are using 8i or greater, then look at temporary global

My apologies. I did not notice the cross posting to the Oracle group, and didn't read close enough.
I have done no performance tuning on Oracle, and know nothing about how it handles temporary tables.

-Doug Miller Received on Mon Dec 16 2002 - 23:26:25 CET