Note:This topic was updated for 9.3.1.
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.
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.
|
