Updating Oracle Database Statistics

You should update database statistics after loading a significant amount of data to your database. Without this step, the database will not use any of the indexes when accessing the data. Depending on the size of your tables, updating statistics may take a while.

To update Oracle database statistics:

1. Start SQL Plus and connect to the instance as SYS or SYSTEM.

2. For each data owner enter this command:

   execute dbms_utility.analyze_schema (' owner','compute');

   where owner is the data owner name in the command. For example, PRODDTA, or DD920.