Re: Question about spooling to flat file

From: <joe17836_at_my-deja.com>
Date: Wed, 01 Nov 2000 19:28:59 GMT
Message-ID: <8tpqtf$dt7$1@nnrp1.deja.com>

In article <8tppn6$cp3$1_at_nnrp1.deja.com>,   joe17836_at_my-deja.com wrote:
> 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.
>

Whoops...obviously forgot my join. But you get the idea...

create table MYTABLE as

   select a.field1,

          b.field2
     from table1 a,
          table2 b

    where a.field3 = b.field3;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 01 2000 - 13:28:59 CST