HELPLIB.HLB  —  RMU72  Analyze  Cardinality  Usage Notes
    o  To use the RMU Analyze Cardinality command for a database, you
       must have the RMU$ANALYZE privilege in the root file ACL for
       the database or the OpenVMS SYSPRV or BYPASS privilege.

    o  You must have the SQL ALTER privilege for the database to
       update a read-only RDB$SYSTEM storage area.

    o  If you specify a name for the table-or-index-name parameter
       that is both an index name and a table name, the RMU Analyze
       Cardinality command performs the requested operation for both
       the table and index.

    o  Although you can alter the cardinality of a unique index
       using the RMU Analyze Cardinality command, it has no effect.
       (A unique index has only unique keys and does not have any
       duplicate keys.) Because the cardinality of a unique index and
       the table it indexes are the same, Oracle Rdb uses the table
       cardinality value when performing operations that involve
       the cardinality of a unique index. Oracle Rdb does not use
       the cardinality value stored for a unique index, nor does it
       attempt to update this value as rows are stored or deleted.

    o  When the RMU Analyze Cardinality command is issued for a
       closed database, the command executes without other users
       being able to attach to the database.
Close Help