o To use the RMU Insert Optimizer_Statistics command for a
database, you must have the RMU$ANALYZE privilege in the root
file access control list (ACL) for the database or the OpenVMS
SYSPRV or BYPASS privilege.
o Cardinality statistics are automatically maintained by
Oracle Rdb. Physical storage and workload statistics are only
collected when you issue an RMU Collect Optimizer_Statistics
command. To get information about the usage of physical
storage and workload statistics for a given query, define
the RDMS$DEBUG_FLAGS logical name to be "O". For example:
$ DEFINE RDMS$DEBUG_FLAGS "O"
When you execute a query, if workload and physical statistics
have been used in optimizing the query, you will see a line
such as the following in the command output:
~O: Workload and Physical statistics used
o The Insert Optimizer_Statistics command modifies the
RDB$LAST_ALTERED date of the RDB$WORKLOAD row so that it is
activated for use by the optimizer.