> One of our developers has just told me that they have a program which
> does a modify to truncate followed by a drop, of a temprary table.
> When asked why he didn't just drop it, he said because he was once
> told that it was faster to modify to truncate, then drop, rather than
> to just drop.
> All the DBA's here were slightly sceptical of this claim so we decided
> to put it to the collected wisdom of the newsgroup. Has anyone else
> heard this, and what is the justification for it ?
instantly. If there is a difference it ain't worth worrying about. I
think your programmer is confusing droping the table with emptying it. A
MODIFY TO TRUNCATED is MUCH faster than a DELETE FROM...
BKB Engineering Ltd., NAIUA Member-at-Large
Edmonton, Alberta http://www.tnc.com/bkb
T6G 0K2 Tel: (403)497-2409
Canada FAX: (403)436-6055