Database statistics

Database management systems determine the most efficient way to execute the queries sent to them based on database statistics. Therefore, for optimal performance of datasets created within ArcSDE geodatabases, you need to keep the database statistics current by frequently updating them.

When a feature class is registered as versioned, adds and deletes tables are created to hold the records that are added to and deleted from a business table. When a version is registered, the process automatically updates the statistics for all the required tables. After that, as changes are made to the feature class, the distribution of information in the tables and indexes changes, causing the database statistics to become outdated.

Database statistics should be updated in the following instances:

• After you perform major operations, such as creating new datasets, adding or removing topology rules, loading large amounts of new data into existing objects, or after compressing the geodatabase.
• On a regular basis to maintain statistics made stale by edits to existing data; for actively edited geodatabases, updating statistics once a week should maintain acceptable performance.

You can update the statistics of feature classes and tables you own from within ArcGIS for Desktop, no matter what supported database you use to store your data. This is the preferred method for updating statistics on individual datasets. Additionally, the geodatabase administrator can update statistics on the geodatabase system tables. For instructions on updating database statistics in ArcGIS for Desktop, see Updating statistics on a geodatabase using Analyze or Analyze Datasets.

Note:

Updating database statistics is an input/output (I/O)-intensive operation. You should plan to update statistics when database traffic is at its lightest.