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.

• Access to Oracle Support
• Accessibility
• Legal Notices

Copyright © 2019 Oracle and/or its affiliates. All rights reserved.