Recommendations To Speed Up Insertion Programs
The following points describe ways to accelerate the execution of the insertion programs:
• Before running the first insertion program:
◦ Rebuild the index on the prime key on the old key / new key table (i.e., those tables prefixed with "CK").
◦ Re-analyze the statistics on the old key / new key table (i.e., those tables prefixed with "CK"). For Oracle users, we strongly recommend using the Oracle-provided PL/SQL package to generate statistics rather than the analyze command.
◦ Alter all indexes on the production tables being inserted into to be unusable.
• After the insertion programs have populated production data, rebuild the indexes and compute statistics for these tables. For Oracle users, we strongly recommend using the Oracle-provided PL/SQL package to generate statistics rather than the analyze command.
Parent topic