Statistics in SQL Server databases
Enterprise 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 use the Analyze command or Analyze Datasets tool in ArcGIS for Desktop. See Updating statistics on a dataset using the Analyze Datasets tool and Using the Analyze Datasets tool to update statistics on geodatabase system tables for instructions. Note:
The Analyze command and geoprocessing tool do not perform a full scan when updating statistics.
- 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
Related Topics
11/14/2016