Computing Statistics

You typically need to gather statistics for your system before the optimizer for your RDBMS can determine the most efficient way to execute SQL statements. If you are a master user with responsibility for verifying source files in a multiuser environment, you will almost always want to gather system statistics after verification to improve performance of the Enterprise Analyzer analysis tools.

Note: Check with your DBA before gathering system statistics. In Oracle, you must have GATHER_SYSTEM_STATISTICS privileges to execute this method. Make sure to restore indexes before gathering system statistics.

To gather system statistics, choose Prepare > Compute Database Statistics. You can view the generated statistics in your RDBMS.