SAP ABAP Table MSSPHYSIDXSTATS (Physical index statistics)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
| Table Category | INTTAB | Structure |
| Structure | MSSPHYSIDXSTATS |
Table Relationship Diagram 
|
| Short Description | Physical index statistics |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  INDID |
MSSINDEXID | INT2 | 5 | 0 | Index id | |||
| 2 | PARTNO |
MSSPARTORD | INT2 | INT2 | 5 | 0 | Partition ordinal (or ID) | ||
| 3 | IDXDESC |
MSSIDXDESC | CHAR | 60 | 0 | Index type description | |||
| 4 | ALLOCDESC |
MSSALLOCDESC | CHAR | 60 | 0 | Allocation unit type description | |||
| 5 | IDXDEPTH |
MSSINDDEPTH | INT4 | 10 | 0 | Depth | |||
| 6 | IDXLEVEL |
MSSINDLEVEL | INT4 | 10 | 0 | Index level | |||
| 7 | AVGFRAG |
MSSAVGFRAG | DEC | 4 | 2 | Average fragmentation | |||
| 8 | FRAGCOUNT |
MSSFRAGCOUNT | DEC | 16 | 0 | Fragment count | |||
| 9 | AVGFRATSZ |
MSSAVGFRAGSZ | DEC | 16 | 4 | Average fragment size in pages | |||
| 10 | PAGCNT |
MSSPAGCNT | DEC | 16 | 0 | Total number of index or data pages | |||
| 11 | AVGPGUSED |
MSSAVGPGUSED | DEC | 4 | 2 | Average of pages used in percent | |||
| 12 | RECCNT |
MSSRECCNT | DEC | 16 | 0 | Number of records in index | |||
| 13 | GHOSTCNT |
MSSGHOSTCNT | DEC | 16 | 0 | Number of ghost records | |||
| 14 | VGHOSTCNT |
MSSVGHOSTCNT | DEC | 16 | 0 | Version ghost record count | |||
| 15 | IDXROWMINLEN |
MSSIDXROWMINLEN | INT4 | INT4 | 10 | 0 | Minimum record size in an index in bytes | ||
| 16 | IDXROWMAXLEN |
MSSIDXROWMAXLEN | INT4 | INT4 | 10 | 0 | Maximum record size in an index | ||
| 17 | ROWAVGLEN |
MSSIDXROWAVGLEN | DEC | 6 | 2 | Average record size in bytes | |||
| 18 | FWDRECCNT |
MSSFWDRECCNT | DEC | 16 | 0 | Forwarded record count | |||
| 19 | CMPRESSPAGES |
MSSCMPRESSPAGES | DEC | 16 | 0 | The number of compressed pages |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 711 |
