Should update database statistics after loading a significant amount of data to the database. Without this step, the database will not use any of the indexes whtn 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:
execue dbms_utility.analyze_schema ('owner','compute');
where owner is the data owner name in the command. for example, PRODDTA, or DD910.
