Previous Topic: Space Management and Database DesignNext Topic: Tuning an Index


Indexing Efficiency

Useful Statistics to Monitor

Statistic

Meaning

Possible action

Orphan count

Indicates the number of orphaned SR8 records.

Tune or rebuild the index if more than 25% of the member records are orphaned.

Index levels

Indicates the number of levels in the index.

Tune or rebuild the index if the number of levels exceeds the number originally calculated

SR8 split

Indicates the number of SR8 splits.

If the number of SR8 splits is high, determine if applications frequently insert a large group of index entries in one spot; tune or rebuild the index to balance it and cleanup orphan index records.

Where the Statistics are Reported