Updating geodatabase statistics in SQL Server databases

Updating geodatabase statistics in SQL Server databases
Release 9.3

NOTE: Applies to geodatabases created with an ArcGIS Server Enterprise license only

ArcSDE geodatabases (licensed with ArcGIS Server Enterprise) 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 don't do this, you will 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:

Transact SQL (T-SQL)

update statistics <table name> with fullscan

ArcSDE sdetable administration command

sdetable –o update_dbms_stats –t <table_name> –m "with fullscan" –i <instance> –D <db>

SqlMaint

sqlmaint –S <server> –U <user> –P <pass> –D <db> –UpdOptiStats 100

NOTE: The analyze command from ArcGIS does not perform a full scan when updating statistics.

Updating geodatabase statistics in SQL Server databases

Updating geodatabase statistics in SQL Server databases

See Also