Updating statistics in a geodatabase on a database server

The SQL Server Query Optimizer uses database statistics to determine the distribution of values in an index. Over time, as the data is edited, the statistics no longer represent the true distribution of data in the indexes and tables. Therefore, if your database statistics are out-of-date, query performance can be negatively affected. Updating statistics after the tables and other data objects in the geodatabase have changed helps optimize query performance.

SQL Server Express is set to automatically update statistics by default. Therefore, in most cases, you do not need update statistics in a geodatabase on a database server.

Follow the steps in this topic to manually analyze statistics when you need to update them more frequently, such as after running a compress operation.

Steps:
  1. Log in as a server administrator or geodatabase administrator, start ArcMap, then open the Catalog window.
  2. Double-click the database server that contains the geodatabase for which you want to update statistics.

    This connects you to the database server.

  3. Right-click the geodatabase, click Administration, then click Geodatabase Maintenance.
  4. Check Analyze on the Geodatabase Maintenance dialog box.
  5. Click OK.

9/18/2012