Hopefully the title describes this sufficiently, but I have a process that runs and performs thousands of individual inserts and updates (nothing I can do to change that). My questions are:
1. Is it worthwhile to disable all the indexes on the tables before the import, and rebuild the indexes afterwards
2. Is it worthwhile (and is it even possible) to disable SQL auditing during the import and enable it when the import is complete.
The import is a binary operation, so either it works or it doesn't. It's also done on off-hours, so I'm not concerned with keeping either indexes up to date, or keeping auditing data.