Performance Tab

Use the Performance tab in the DTS Settings dialog to set options that can affect the performance of a DTS job.

Update Statistics options

The update statistics command can be automatically executed for database engines that support it. This enables peak performance of the database engine when running jobs with large numbers of rows.

You can select various options for updating statistics. The effectiveness of your selections varies according to the database engine; refer to your database's documentation to determine optimum settings for each situation.

Miscellaneous options

Note: Clear the checkbox if an incompatibility or other unexpected problem occurs.

See also

DTS Settings