Updating geodatabase statistics in DB2 databases
Updating geodatabase statistics in DB2 databases
|
| Release 9.3 |
   |
DB2 provides the RUNSTATS statement to allow you to update the statistics on a particular table.
If you decide to update the statistics of all or some of the feature class tables with the DB2 RUNSTATS statement, use the following syntax:
RUNSTATS ON TABLE <table_name> WITH DISTRIBUTION AND DETAILED INDEXES ALL
You can also update the statistics for every table in a designated schema with the UPDATE STATISTICS command, as shown in the example below:
db2 REORGCHK UPDATE STATISTICS ON SCHEMA SDE
In this example, the SDE schema name is specified. This will update the statistics on all the ArcSDE system tables, which are stored in the SDE user's schema.
For more information on the DB2 SQL RUNSTATS and UPDATE STATISTICS statements, refer to the IBM DB2 Universal Database Command Reference.
