Which is faster...
Posted: Wed Jan 27, 2010 9:06 pm
Is it faster to drop a table and recreate it or is it faster to drop all the records in the table?
The table in question will only have up to 25 records with 12 fields each.
I suppose dropping all records then optimizing table is slower than dropping an recreating an empty table.
What do best practices indicate?
Thanks!
The table in question will only have up to 25 records with 12 fields each.
I suppose dropping all records then optimizing table is slower than dropping an recreating an empty table.
What do best practices indicate?
Thanks!