Example 1
The following command analyzes the JH_EMPLOYEE_ID and SH_
EMPLOYEE_ID indexes in the mf_personnel database:
$ RMU/ANALYZE/INDEXES MF_PERSONNEL.RDB JH_EMPLOYEE_ID,SH_EMPLOYEE_ID -
_$ /OUTPUT=EMP_ID_INDEX.LIS
Example 2
The following commands demonstrate the differences you see
when you analyze a nonranked sorted index and a ranked sorted
index. Note the differences in the values for the Duplicate
nodes. The nonranked sorted index displays 80 duplicate nodes.
The ranked sorted index (before more duplicates are added)
displays 0 duplicate nodes for the same data. After hundreds
of more duplicates are added, the ranked sorted index shows only
3 duplicate nodes. The differences you see are because of the
different way duplicate records are stored for nonranked sorted
indexes and ranked sorted indexes. See the Description help entry
under this command for details on these differences.
$ ! Analyze a nonranked sorted index:
$ !
$ RMU/ANALYZE/INDEXES MF_PERSONNEL.RDB JH_EMPLOYEE_ID
----------------------------------------------------------------------------
Indices for database - USER1:[DB]MF_PERSONNEL.RDB;1
----------------------------------------------------------------------------
Index JH_EMPLOYEE_ID for relation JOB_HISTORY duplicates allowed
Max Level: 2, Nodes: 4, Used/Avail: 768/1592 (48%), Keys: 103, Records: 20
Duplicate nodes: 80, Used/Avail: 2032/4696 (43%), Keys: 80, Records: 254
----------------------------------------------------------------------------
$ ! Analyze a ranked sorted index defined on the same column as the
$ ! nonranked sorted index:
$ RMU/ANALYZE/INDEXES MF_PERSONNEL.RDB JH_EMPLOYEE_ID_RANKED
----------------------------------------------------------------------------
Indices for database - USER1:[DB]MF_PERSONNEL.RDB;1
----------------------------------------------------------------------------
Index JH_EMPLOYEE_ID_RANKED for relation JOB_HISTORY duplicates allowed
Max Level: 2, Nodes: 11, Used/Avail: 2318/4378 (53%), Keys: 110, Records: 20
Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 80, Maps: 80, Records: 254
----------------------------------------------------------------------------
$ !
$ ! Insert many duplicates and analyze the ranked sorted index again:
$ !
$ RMU/ANALYZE/INDEXES MF_PERSONNEL.RDB JH_EMPLOYEE_ID_RANKED
----------------------------------------------------------------------------
Indices for database - USER1:[DB]MF_PERSONNEL.RDB;1
----------------------------------------------------------------------------
Index JH_EMPLOYEE_ID_RANKED for relation JOB_HISTORY duplicates allowed
Max Level: 2, Nodes: 13, Used/Avail: 2705/5174 (52%), Keys: 112, Records: 20
Duplicate nodes:3, Used/Avail:850/1194 (71%), Keys:80, Maps: 83, Records:2964
----------------------------------------------------------------------------