Updating statistics on a geodatabase licensed under ArcGIS Server Enterprise |
|
Release 9.3 |
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.
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]
Tip
|