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.