Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Question about spooling to flat file
don't create the table, inserting the data and retrieving it are extra
overhead.
<joe17836_at_my-deja.com> wrote in message news:8tppn6$cp3$1_at_nnrp1.deja.com...
> When spooling the results of a complex join to a flat file, is it
> faster to do:
>
> create table MYTABLE as
> select a.field1,
> b.field2
> from table1 a,
> table2 b;
>
> and then spool MYTABLE to a flat file? Or is it faster to simply do
> the join (i.e. without doing the create table as) and spool to the flat
> file?
>
> Thank you in advance.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 02 2000 - 23:37:51 CST