Truncate and insert vs drop and create

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:07:14 CST