Statistics in SQL Server databases

ArcSDE geodatabases stored in SQL Server databases can be set to update statistics automatically. To do this, leave the database parameters AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS enabled. Disable autoshrink.

If you do not do this, you need to update statistics with a full scan on all tables involved in your system, including the sde_state_lineages and sde_states tables. To update statistics with a full scan, use one of the following:

To update statistics for a particular table, you can also use the Analyze command in ArcGIS Desktop. See Updating statistics on a geodatabase using Analyze for instructions.

NoteNote:

The Analyze command and geoprocessing tool do not perform a full scan when updating statistics.

Related Topics


11/18/2013