Overview

During the following processes, a large number of records are copied into history.

• Close Roster
• Close Actuals
• Close Pay.

For example, during the Close Roster process, PayGlobal copies records from:

• TRANSROSTERCURRENTMASTER to TRANSROSTERHISTORICALMASTER
• CURRENTROSTERALLOWANCE to HISTORICALROSTERALLOWANCE
• CURRENTROSTERTIMEBAND to HISTORICALROSTERTIMEBAND
• CURRENTAVAILABILITY to HISTORICALAVAILABILITY.

This can impact on the speed performance of your database. To minimize the impact, you should have a database maintenance plan to update database statistics.

Note: For more information about how SQL Server uses database statistics, see SQL Server Books Online - Update Statistics.

Create a Database Maintenance Plan

A company's database administrator generally has a database maintenance plan in place, which they may run using a script.

The following procedure shows you where you can set up a database maintenance plan using The Database Maintenance Plan Wizard.

1. Open SQL Server Enterprise Manager.
2. In the Console tree, expand your server directory and click the Management folder to see Database Maintenance Plans.
3. Right-click Database Maintenance Plans.
4. Click New Maintenance Plan.

   The Database Maintenance Plan Wizard appears.

The settings that you will use are specific to the requirements of your database.