VMS Help  —  RMU72  Delete Optimizer Statistics, Usage Notes
    o  To use the RMU Delete 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  Oracle Corporation recommends that you execute an RMU Show
       Optimizer_Statistics command with the Output qualifier prior
       to executing an RMU Delete Optimizer_Statistics command. If
       you accidentally delete statistics, you can replace them
       by issuing an RMU Insert Optimizer_Statistics command and
       specifying the statistical values contained in the output
       file.
Close Help