Data Element list used by SAP ABAP Table MSSPHYSIDXSTATS (Physical index statistics)
SAP ABAP Table
MSSPHYSIDXSTATS (Physical index statistics) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSSALLOCDESC | Allocation unit type description | ||
| 2 | MSSAVGFRAG | Average fragmentation | ||
| 3 | MSSAVGFRAGSZ | Average fragment size in pages | ||
| 4 | MSSAVGPGUSED | Average of pages used in percent | ||
| 5 | MSSCMPRESSPAGES | The number of compressed pages | ||
| 6 | MSSFRAGCOUNT | Fragment count | ||
| 7 | MSSFWDRECCNT | Forwarded record count | ||
| 8 | MSSGHOSTCNT | Number of ghost records | ||
| 9 | MSSIDXDESC | Index type description | ||
| 10 | MSSIDXROWAVGLEN | Average record size in bytes | ||
| 11 | MSSIDXROWMAXLEN | Maximum record size in an index | ||
| 12 | MSSIDXROWMINLEN | Minimum record size in an index in bytes | ||
| 13 | MSSINDDEPTH | Depth | ||
| 14 | MSSINDEXID | Index id | ||
| 15 | MSSINDLEVEL | Index level | ||
| 16 | MSSPAGCNT | Total number of index or data pages | ||
| 17 | MSSPARTORD | Partition ordinal (or ID) | ||
| 18 | MSSRECCNT | Number of records in index | ||
| 19 | MSSVGHOSTCNT | Version ghost record count |