Re: Truncate and insert vs drop and create

Try using NOLOGGING on the CTAS. It will run faster. Toss in PARALLEL  DEGREE X ) with a proper storage clause too if necessary.

-Kevin

"Philip Morrow" <cracker_at_mymorrow.com> wrote in message news:6Yl18.11711$_w.1271779_at_typhoon.tampabay.rr.com...
> Which is the better way to empty a table and reload data.
>
> truncate, then use insert into x select ..... from y
>
> or is it better to
>
> drop table, then create table x as select ... from y???
>
> I'm just wondering which is faster. I've tried both when putting about
> 24000 records into a table and I couldn't see much of a difference.
>
> Thanks
> Phil
>
>
Received on Wed Jan 16 2002 - 15:16:07 CST