Library /sys$common/syshlp/RMUDISPLAY72.HLB  —  Overview  Fields  Hash Index Statistics Screen

1  –  hash_insertions_field

    This field gives the number of hash key insertions in the
    database's hashed indexes. It includes unique key insertions
    as well as duplicate key insertions.

2  –  _____duplicates_field_

    This field gives the number of duplicate key updates in the
    database's hashed indexes.

3  –  hash_deletions_field

    This field gives the number of hash key deletions from the
    database's hashed indexes. It includes unique key deletions as
    well as duplicate key deletions.

4  –  ____duplicates_field_

    This field gives the number of duplicate key deletions in the
    database's hashed indexes.

5  –  hash_scans_field

    This field gives the number of hashed index scans, including both
    retrieval and update scans, that were opened on the database's
    hashed indexes. A scan is defined as the sequential processing
    of the records that meet the search criteria of a query. Hashed
    scans then refer to the case where duplicate records are returned
    that meet the search criteria of a query from a scan of the
    hashed index.

6  –  hash_index_fetches_field

    This field gives the number of hashed index nodes that were
    fetched on a successful search of the database's hashed indexes.
    This includes fetches of duplicate nodes as well as bucket
    fragment nodes.

7  –  __bucket_fragments_field

    This field gives the number of bucket fragments that were fetched
    on a successful search of the database's hashed indexes.

8  –  ___duplicate_nodes_field

    This field gives the number of duplicate nodes that were fetched
    on a successful search of the database's hashed indexes.

9  –  hash_bucket_stores_field

    This field gives teh number of hash index buckets stored in the
    index. A hash index bucket contains one or more hash keys.
Close Help