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 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 Central Coding database.