Question about spooling to flat file

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 Wed Nov 01 2000 - 13:08:29 CST