Note:This topic was updated for 9.3.1.

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.

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.