VMS Help  —  RMU72  Insert Optimizer Statistics, Usage Notes
    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.
Close Help