Can anyone tell me if there is any significant difference in speed using drop
and recreate table vrs delete rows in existing table on a table with a large
number of records?

Tom,

Yes, dropping and recreating the table does take fewer resources than
deleing a large number of rows. (Of course, how large is large?)

However, a less obtrusive way to remove all rows is TRUNCATE TABLE.

If you are using constraints, they will interfere with TRUNCATE and DROP
table, but not with deleting rows.

RLF
[quoted text, click to view]