Frank van Bortel wrote:
> laszlo_spamhole_at_freemail.hu wrote:
>
>
>>Hmm... actually, I think I see your point. I'm not sure why I'm
>>dropping the table instead of doing a DELETE FROM, when the data needs
>>to be recreated from scratch.
>
>
> Apart from comments pointing towards "you should not be doing this":
> a truncate is much faster than a delete from .. However: it is DDL,
> not DML
And a global temporary table might eliminate the need to even think
about along with the logging overhead.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue May 24 2005 - 15:24:38 CDT
