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.