It is a good idea to drop and re-create the indexes to improve the
Please reply to the whole group only!
"GriffithsJ" <jonathan.griffithsipuk.com> wrote in message
> I wish to delete/import a lot of data into a database and want it to run
> quickly as possible (using DTS here).
> The triggers don't need to run, so to improve performance I should
> disable the triggers.
> Is there anything else that I should be considering here in terms of the
> database schema? What about indexes ...