VMS Help  —  RMU72  Analyze  Cardinality
    Generates a formatted display of the actual and stored
    cardinality values for specified tables and indexes. Also, if
    the stored cardinality values are different from the actual
    cardinality values, the RMU Analyze Cardinality command allows
    you to update the stored cardinality values.

                                   NOTE

       Beginning in Oracle Rdb Version 7.0, the RMU Analyze
       Cardinality command has been deprecated and might be removed
       in future versions of Oracle Rdb. The features available
       through this command are now available through the RMU
       Collect Optimizer_Statistics command and the RMU Show
       Optimizer_Statistics command.

       In addition, updating cardinality information for indexes
       using the RMU Analyze Cardinality command may cause poor
       performance because the prefix cardinality information is
       not collected.

       Therefore, Oracle Corporation recommends that you use the
       RMU Collect Optimizer_Statistics and RMU Show Optimizer_
       Statistics commands instead of the RMU Analyze Cardinality
       command.

       See Collect_Optimizer_Statistics and Show Optimizer_
       Statistics for information on the RMU Collect Optimizer_
       Statistics and the RMU Show Optimizer_Statistics commands.
Additional Information: explode extract
Description Format Parameters Command Qualifiers Usage Notes Examples
Close Help