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:

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.

NoteNote:

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

Related Topics

8/21/2013