Ever wonder how to improve your database performance? You may gather the statistics on your database schema or database table, to improve Cost Based Optimization (CBO) of your SQL. You may use the command as below to perform the gather table statistics: -

Gather Table Statistics SQL

SQL> EXEC fnd_stats.gather_table_stats(‘GL’,’GL_BALANCES’,
estimate_percent => '99', degree => 8, cascade=>TRUE);

Cascade option was set to TRUE if you want the index to be analyze as well in the gather statistics.