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").
Alter all indexes except primary key and unique indexes on the production tables being inserted into to be unusable.
Gather statistics on the old key/new key table(s) using the DBMS_STATS PL/SQL package.
After the insertion programs have populated production data,
Rebuild the indexes on the production tables.
Gather statistics using the DBMS_STATS PL/SQL package after insertion programs have completed and the indexes have been rebuilt.
Validate the production schema to ensure that all schema changes made during conversion have been reversed properly.
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]