Hi,

does the "auto update stats" feature of statistics as an impact of the
performance during bulk insert operation?

Does it recommended to disable the auto update for the stats, and manually
update these stats at the end of the loading process?

I'll load 6millions of rows every day :
1. I truncate my tables
2. I reload my tables

Incremental loading cannot work correctly in my case. its why I must reload
this information. Its why I want to optimize my loading process.

Thamks.

Jerome.

Turning of auto update stats will result in a small improvement in
performance. However, what will make for a far larger improvement in
performance is to drop the indexes on the table and recreate them after the
import has completed.

--
Jacco Schalkwijk
SQL Server MVP


"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote