PingDirectory

About the Index Summary Statistics table

The PingDirectory server automatically generates an Index Summary Statistics table, which you can use to determine the optimal configuration for your system’s indexes.

The table only generates when you run the rebuild-index tool in offline mode. The table generates after any LDIF import or an index rebuild. It is written to system out and to logs/tools/rebuild-index-summary.txt.

The table displays the following information:

  • The current index entry limit set by the index-entry-limit property on the local database configuration

  • The number of keys whose entry count exceeds this limit, if any

  • The maximum entry count for any key in the index

  • A histogram of the number of keys whose entry falls within a range of values

The following image is an example of the Index Summary Statistics table for the sn.equality and the sn.substring indexes.

In this figure, there are seven substrings whose entry counts exceed the index-entry-limit of 4000. Six of the substrings are in the 10000-99999 range with the maximum entry count being 13419. By deduction, one more substring must be present in the 1000-9999 range that exceeds the index-entry-limit of 4000. These substrings could be expensive for search operations.

A screen capture of the Index Summary Statistics table showing the entry counts of each index.
Example of an Index Summary Statistics Table