Re: fastest way of deleting all rows in a table

Ed Stevens <nospam_at_noway.nohow> wrote in news:97pu5v8o602dtgl65etjqbq957ffn1vtrg_at_4ax.com:

> Drop / Create incurs large amounts of storage management activity as
> well as updating the dictionary (and attendant redo acitivty)

Not to mention requiring you to recreate all indexes, triggers, constraints, and grants.

Just use truncate and make your life simpler. Received on Fri Feb 28 2003 - 09:19:08 CST