• Ensure that statistics are recalculated after data has been inserted into the staging tables. For Oracle users, we strongly recommend using the Oracle-provided PL/SQL package to generate statistics rather than the analyze command.

• Object validation programs should be run multi threaded.

• Execute shorter running validation processes (e.g., less records) first so that the error data can be analyzed while other processes are busy running.

• Referential integrity validation programs run fairly quickly without much tuning. However, additional benefits are gained by running several programs at the same time.

• Remember that the object validation programs can be run in "validate every n th row". We recommend running these programs using a largish value for this parameter until the pervasive problems have been rectified.