Logo Background

Gather Table Statistics In Oracle 10g

  • By on August 31, 2008 | No Comments

    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.

    Previous
    Next
    » Unix Zip Command
Leave a Comment