---
title: About the Index Summary Statistics table
description: The PingDirectory server automatically generates an Index Summary Statistics table, which you can use to determine the optimal configuration for your system's indexes.
component: pingdirectory
version: 11.0
page_id: pingdirectory:pingdirectory_server_administration_guide:pd_ds_index_summary_stats_table
canonical_url: https://docs.pingidentity.com/pingdirectory/11.0/pingdirectory_server_administration_guide/pd_ds_index_summary_stats_table.html
revdate: September 13, 2023
---

# 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.](_images/xjx1564011706927.png)Example of an Index Summary Statistics Table
