1. Home
  2. Resources
  3. SAP Tables
  4. MSSIDXUSAGESTATS - Index usage stats output from MSS_GET_INDEX_USE_STATS

SAP Table MSSIDXUSAGESTATS

Index usage stats output from MSS_GET_INDEX_USE_STATS

MSSIDXUSAGESTATS (Index usage stats output from MSS_GET_INDEX_USE_STATS) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MSSIDXUSAGESTATS to other SAP tables.

MSSIDXUSAGESTATS table fields

Field Data element Checktable Datatype Length Decimals
DBNAME Database name MSSDB CHAR 128 0
SCHEMANAME Schema name MSSSCHEMA CHAR 128 0
TABNAME Table name MSSTABLE CHAR 128 0
INDEXNAME Index name MSSINDEX CHAR 128 0
USER_SEEKS Index usage - Number of seeks by user queries. MSSUSEEKS DEC 15 0
USER_SCANS Index usage - Number of scans by user queries. MSSUSCANS DEC 15 0
USER_LOOKUPS Index usage: Number of lookups by user queries MSSULOOKUPS DEC 15 0
USER_UPDATES Index usage: Number of updates by user queries MSSUUPDATES DEC 15 0
USER_TOTALOPS Index usage: Total user operations on the index MSSUTOTALOPS DEC 15 0
LST_USER_SEEK Index usage: Last user seek (sql datetime) MSSLSTUSEEK CHAR 24 0
LST_USER_SCAN Index usage: Last user scan (sql datetime) MSSLSTUSCAN CHAR 24 0
LST_USER_LOOKUP Index usage: Last user lookup (sql datetime) MSSLSTULOOKUP CHAR 24 0
LST_USER_UPDATE Index usage: Last user update (sql datetime) MSSLSTUUPDATE CHAR 24 0
SYSTEM_SEEKS Index usage: Number of seeks by system queries MSSSYSSEEKS DEC 15 0
SYSTEM_SCANS Index usage: Number of scans by system queries MSSSYSSCANS DEC 15 0
SYSTEM_LOOKUPS Index usage: Number of lookups by system queries MSSSYSLOOKUPS DEC 15 0
SYSTEM_UPDATES Index usage: Number of updates by system queries MSSSYSUPDATES DEC 15 0
LAST_SYS_SEEK Index usage: Time of last system seek MSSLSTSYSSEEK CHAR 24 0
LAST_SYS_SCAN Index usage: Time of last system scan MSSLSTSYSSCAN CHAR 24 0
LAST_SYS_LOOKUP Index usage: Time of last system lookup MSSLSTSYSLOOKUP CHAR 24 0
LAST_SYS_UPDATE Index usage: Time of last system update MSSLSTSYSUPDATE CHAR 24 0