Data Element list used by SAP ABAP Table MSSOPUSESTATS (Combined index operational and use statistics)
SAP ABAP Table 
MSSOPUSESTATS (Combined index operational and use statistics) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSSAVGPGLCKWAIT | Average pagelock wait ms | |
| 2 | Data Element |
MSSAVGPGLTCHWAIT | Average page latch wait ms | |
| 3 | Data Element |
MSSAVGROWLCKWAIT | Average rowlock wait ms | |
| 4 | Data Element |
MSSAVGTOTLLWAIT | Average wait for a latch or a lock | |
| 5 | Data Element |
MSSAVPGIOLTCHWAIT | Average page io latch wait | |
| 6 | Data Element |
MSSCOLUMNVALUEPULLINROWCNT | Index op stats: Count of values pulled in-row | |
| 7 | Data Element |
MSSCOLUMNVALUEPUSHOFFROWCNT | Index op stats: Count of values pushed off-row for a new row | |
| 8 | Data Element |
MSSDB | Database name | |
| 9 | Data Element |
MSSFORWARDEDFTCHCNT | Index op stats: Rows fetched through a forwarding record | |
| 10 | Data Element |
MSSIDXOPTOTALOPS | Index op stats: Total operations on the index | |
| 11 | Data Element |
MSSINDEX | Index name | |
| 12 | Data Element |
MSSINDEXLCKPROMOTIONATTEMPTCNT | Index op stats: Index lock promotion attempts | |
| 13 | Data Element |
MSSINDEXLCKPROMOTIONCNT | Index op stats: Index lock promotions | |
| 14 | Data Element |
MSSLEAFALLOCCNT | Index op stats: Count of leaf-level page allocations | |
| 15 | Data Element |
MSSLEAFDELCNT | Index op stats: Cumulative count of leaf-level deletes | |
| 16 | Data Element |
MSSLEAFGHOSTCNT | Index op stats: Count of leaf-level rows marked for delete | |
| 17 | Data Element |
MSSLEAFINSCNT | Index op stats: Cumulative count of leaf-level inserts | |
| 18 | Data Element |
MSSLEAFPAGEMERGECNT | Index op stats: Count of page merges at the leaf level | |
| 19 | Data Element |
MSSLEAFUPDCNT | Index op stats: Cumulative count of leaf-level updates | |
| 20 | Data Element |
MSSLOBFTCHINBYTES | Index op stats: Count of LOB data bytes retrieved | |
| 21 | Data Element |
MSSLOBFTCHINPAGES | Index op stats: Lob fetch pages | |
| 22 | Data Element |
MSSLOBORPHANCREATECNT | Index op stats: Count of orphan LOB created | |
| 23 | Data Element |
MSSLOBORPHANINSCNT | Index op stats:Orphan LOB values inserted during bulkop | |
| 24 | Data Element |
MSSNONLEAFALLOCCNT | Index op stats: Count of non leaf-level page allocations | |
| 25 | Data Element |
MSSNONLEAFDELCNT | Index op stats: Count of deletes above the leaf level | |
| 26 | Data Element |
MSSNONLEAFINSCNT | Index op stats: Count of inserts above the leaf level | |
| 27 | Data Element |
MSSNONLEAFPAGEMERGECNT | Index op stats: Count of page merges above the leaf level | |
| 28 | Data Element |
MSSNONLEAFUPDCNT | Index op stats: Count of updates above the leaf level | |
| 29 | Data Element |
MSSPAGEIOLTCHWAITCNT | Index op stats: I/O page latch wait count | |
| 30 | Data Element |
MSSPAGEIOLTCHWAITMS | Index op stats: I/O page latch wait in ms | |
| 31 | Data Element |
MSSPAGELCKCNT | Index op stats: Page lock count | |
| 32 | Data Element |
MSSPAGELCKWAITCNT | Index op stats: Page lock wait count | |
| 33 | Data Element |
MSSPAGELCKWAITMS | Index op stats: Page lock wait in milliseconds | |
| 34 | Data Element |
MSSPAGELTCHWAITCNT | Index op stats: Latch wait count | |
| 35 | Data Element |
MSSPAGELTCHWAITMS | Index op stats: Latch waits ms | |
| 36 | Data Element |
MSSRANGESCANCNT | Index op stats: Count of range and table scans | |
| 37 | Data Element |
MSSROWLCKCNT | Index op stats: Count of row locks requested | |
| 38 | Data Element |
MSSROWLCKWAITCNT | Index op stats: Count of row lock waits | |
| 39 | Data Element |
MSSROWLCKWAITMS | Index op stats: Row lock waits in ms | |
| 40 | Data Element |
MSSROWOVERFLOWFTCHINBYTES | Index op stats: Data bytes from ROW_OVERFLOW_DATA | |
| 41 | Data Element |
MSSROWOVERFLOWFTCHINPAGES | Index op stats: Data pages from ROW_OVERFLOW_DATA | |
| 42 | Data Element |
MSSSCHEMA | Schema name | |
| 43 | Data Element |
MSSSINGLETONLOOKUPCNT | Index op stats: Count of single row retrievals | |
| 44 | Data Element |
MSSTABLE | Table name | |
| 45 | Data Element |
MSSTOTLLCOUNT | Total lock or latch wait events | |
| 46 | Data Element |
MSSTOTLLTIME | Total lock/latch wait time | |
| 47 | Data Element |
MSSULOOKUPS | Index usage: Number of lookups by user queries | |
| 48 | Data Element |
MSSUSCANS | Index usage - Number of scans by user queries. | |
| 49 | Data Element |
MSSUSEEKS | Index usage - Number of seeks by user queries. |
