Optimizing Queries

For Oracle Database, to optimize queries, after the first large load (for example, tasks, profiles, or balances), and then periodically, perform the following script:

begin dbms_stats.gather_schema_stats('<arm schema>'); end;

For example:

begin dbms_stats.gather_schema_stats('prod7625_abc');end