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.