Data Element list used by SAP ABAP Table MSSIDXUSAGESTATS (Index usage stats output from MSS_GET_INDEX_USE_STATS)
SAP ABAP Table
MSSIDXUSAGESTATS (Index usage stats output from MSS_GET_INDEX_USE_STATS) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSSDB | Database name | ||
| 2 | MSSINDEX | Index name | ||
| 3 | MSSLSTSYSLOOKUP | Index usage: Time of last system lookup | ||
| 4 | MSSLSTSYSSCAN | Index usage: Time of last system scan | ||
| 5 | MSSLSTSYSSEEK | Index usage: Time of last system seek | ||
| 6 | MSSLSTSYSUPDATE | Index usage: Time of last system update | ||
| 7 | MSSLSTULOOKUP | Index usage: Last user lookup (sql datetime) | ||
| 8 | MSSLSTUSCAN | Index usage: Last user scan (sql datetime) | ||
| 9 | MSSLSTUSEEK | Index usage: Last user seek (sql datetime) | ||
| 10 | MSSLSTUUPDATE | Index usage: Last user update (sql datetime) | ||
| 11 | MSSSCHEMA | Schema name | ||
| 12 | MSSSYSLOOKUPS | Index usage: Number of lookups by system queries | ||
| 13 | MSSSYSSCANS | Index usage: Number of scans by system queries | ||
| 14 | MSSSYSSEEKS | Index usage: Number of seeks by system queries | ||
| 15 | MSSSYSUPDATES | Index usage: Number of updates by system queries | ||
| 16 | MSSTABLE | Table name | ||
| 17 | MSSULOOKUPS | Index usage: Number of lookups by user queries | ||
| 18 | MSSUSCANS | Index usage - Number of scans by user queries. | ||
| 19 | MSSUSEEKS | Index usage - Number of seeks by user queries. | ||
| 20 | MSSUTOTALOPS | Index usage: Total user operations on the index | ||
| 21 | MSSUUPDATES | Index usage: Number of updates by user queries |