ArcGIS Server Banner

Updating statistics on a geodatabase licensed under ArcGIS Server Enterprise

Updating statistics on a geodatabase licensed under ArcGIS Server Enterprise

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About updating geodatabase statistics

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

You should update database statistics before and after a compress operation; after you add or remove topology rules; and after you have finished importing, loading, or copying data into an ArcSDE geodatabase.

To do this, you can use the analyze command in ArcCatalog to help maximize query performance. The analyze command updates the statistics of business tables, feature tables, and delta tables along with the statistics on those tables’ indexes.

When you update the statistics for a feature dataset, statistics for all the feature classes in that feature dataset are updated. If the feature dataset contains a geometric network, the network tables are also updated.

You could also update statistics using the sdetable ArcSDE administration command. Using this command, you can update statistics for specific tables, indexes, or all indexes.

Optionally, you can use the statistic tools provided with your DBMS to update statistics. Consult your DBMS documentation for information on how to use those tools.

NOTE: If your ArcSDE geodatabase is stored in a DB2 for z/OS database, you must use the DBMS tools rather than ArcCatalog or sdetable.

How to

Update statistics using Analyze in ArcCatalog

  1. Connect to the geodatabase under Database Connections in the Catalog tree that contains the dataset on which you want to update statistics.
  2. Right-click the dataset in the Catalog tree. This can be a feature dataset, feature class, or table.
  3. Click Analyze.
  4. Check those tables you want analyzed.
  5. Click OK.

Update statistics using the sdetable ArcSDE administration command

At the command prompt, issue the sdetable command with the update_dbms_stats operation. The syntax for this command is

sdetable –o update_dbms_stats –t <table_name> [–K <keyword>] [–n {ALL|<index_name>}] 
[–i <service>] [–s <server_name>] [–D <database>] –u <user_name>
 [–p <password>] [–N] [–q]

Where a word or phrase is enclosed in angle brackets <>, you need to supply the values specific to your database. Any option enclosed in square brackets [] is optional depending on the circumstances. For example, if you do not specify a server name, ArcSDE will assume it is to be run on the current server. If you don't supply a database password in the command, you will be prompted to input it before the command proceeds.

Tip

  • For details on the use of sdetable and other administration commands, consult the Administration Command Reference that is provided with ArcGIS Server Enterprise. You can also download a PDF version of the file from the Geodatabase Resource Center.

See Also

  • About updating geodatabase statistics