ArcGIS Server Banner

Updating statistics on geodatabases on ArcSDE database servers

Updating statistics on geodatabases on ArcSDE database servers

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About updating statistics

After adding large amounts of data to an ArcSDE geodatabase, performing a large number of edits, or compressing your geodatabase, you should update the database statistics.

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 will help maximize query performance.

SQL Server Express is set to automatically update statistics based on the number of edits performed. Follow the steps below to manually analyze statistics when you need to update them more frequently such as after running a compress operation.

How to update statistics on a geodatabase on an ArcSDE database server

  1. In ArcCatalog, connect to the database server that contains the geodatabase for which you want to update statistics.
  2. Right-click the geodatabase for which you want to update statistics.
  3. Click Administration and click Geodatabase Maintenance.
  4. Check Analyze on the Geodatabase Maintenance dialog box.
  5. Click OK.

Tip

  • To update a geodatabase's statistics, you must be an ArcSDE database server administrator or have administrator privileges on that geodatabase.

See Also

  • About updating geodatabase statistics
  • Compressing a geodatabase on an ArcSDE database server