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 database 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 database users, we strongly recommend using the Oracle-provided PL/SQL package to generate statistics rather than the analyze command.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.