Data elements related to index

Edit online

This reference topic provides information about data element that is related to index.

The following table summarizes the data element that is related to index.
Table 1. Data elements related to index
Data element name PINDEX SINDEX PHIDAM PSINDEX Type Description

DBX_NUM_IPS

Y

Y

Y

Y

DB

The number of index pointer segments in the index database.

DBX_NUM_IPS_OVFL

-

Y

-

-

DB

The number of index pointer segments in the overflow data set. The number is the same as the number of duplicated keys.

DBX_PCT_IPS_OVFL

-

Y

-

-

DB

The percentage of index pointer segments in the overflow data set compared to the total number of IPS segments.

DBX_FLAG_SEGMENT_STAT

Y

Y

Y

Y

DB

The indicator that shows whether the SEGMENT_STAT option of Database Sensor is specified.