RMUDISPLAY72.HLB  —  Overview  Fields  Index Statistics Insertion screen , node_creations_field
    This field gives the total number of index nodes created during
    insertion of index entries into the index trees. This includes
    root, leaf, and duplicate nodes created within user- and system-
    defined indexes. Nodes are created three ways:

    o  When an index is first defined

    o  When a node cannot accommodate an insertion, causing it to
       overflow into a new node (node splitting)

    o  When the first duplicate for a particular key is inserted into
       an index, causing a duplicate node to be created

    The total number of nodes created and the associated fields
    should be relatively small, except for an initial load of the
    database with indexes already defined, or for creation of indexes
    on already-stored data.
Close Help