Analyzing tables and indexes for performance

Oracle recommends analyzing all tables and indexes for better performance. You should perform this analysis whenever a significant amount of coding data is entered. To help analyze tables and indexes, Oracle recommends that you run the following Oracle database utilities:

• dbms_utility.analyze_schema—Run this utility as the Oracle Central Coding application schema owner.

  This utility updates the Oracle system tables that are used to perform analysis on a schema.

• dbms_utility.analyze_schema—Run this utility to update the Oracle system tables for the Oracle Central Coding database.