This function updates the statistical information of the database. This includes the number of table entries, the size of tables and indexes, and the value distribution (distinct values) of indexes or columns; it stores this information in the catalog.
The ADABAS optimizer needs these specifications to find out the best processing strategy for complex SQL statements. If the sizes or value assignments have considerably changed in the database, a new Update~Statistics is required. We recommend to perform an Update~Statistics once a week.
If ADABAS determines differences between the optimizer assumptions from the last Update~Statistics and the current state of a table, it attempts to perform an implicit Update~Statistics. If there are conflicting locks, this attempt might be aborted, so that the explicit Update~Statistics is not replaced completely.
The operation can be applied to particular tables, particular columns or to all base tables of the database server. In the Schedule Manager (see Section Backup / Schedule Manager ), an Update Statistics is always performed on the whole serverdb.