MSSIDXOPSTATS SAP (Index operational stats output from MSS_GET_INDEX_OP_STATS) Structure details
Description: Index operational stats output from MSS_GET_INDEX_OP_STATS
Related tables to MSSIDXOPSTATS
Access table MSSIDXOPSTATS
Structure field list including key, data, relationships and ABAP select examples
MSSIDXOPSTATS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Index operational stats output from MSS_GET_INDEX_OP_STATS" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MSSIDXOPSTATS TYPE MSSIDXOPSTATS.
The MSSIDXOPSTATS table consists of various fields, each holding specific information or linking keys about Index operational stats output from MSS_GET_INDEX_OP_STATS data available in SAP. These include SCHEMANAME (Schema name), TABNAME (Table name), INDEXNAME (Index name), TOTAL_OPS (Index op stats: Total operations on the index).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP MSSIDXOPSTATS structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
DBNAME | Database name | MSSDB | CHAR | 128 | MSSSYSNAME | ||||
SCHEMANAME | Schema name | MSSSCHEMA | CHAR | 128 | MSSSYSNAME | ||||
TABNAME | Table name | MSSTABLE | CHAR | 128 | MSSSYSNAME | ||||
INDEXNAME | Index name | MSSINDEX | CHAR | 128 | MSSSYSNAME | ||||
TOTAL_OPS | Index op stats: Total operations on the index | MSSIDXOPTOTALOPS | DEC | 15 | |||||
AVPGIOLTCHWAIT | Average page io latch wait | MSSAVPGIOLTCHWAIT | DEC | 15(3) | |||||
AVGPGLTCHWAIT | Average page latch wait ms | MSSAVGPGLTCHWAIT | DEC | 15(3) | |||||
AVGROWLCKWAIT | Average rowlock wait ms | MSSAVGROWLCKWAIT | DEC | 15(3) | |||||
AVGPGLCKWAIT | Average pagelock wait ms | MSSAVGPGLCKWAIT | DEC | 15(3) | |||||
LEAF_INSERT_COUNT | Index op stats: Cumulative count of leaf-level inserts | MSSLEAFINSCNT | DEC | 15 | |||||
LEAF_DELETE_COUNT | Index op stats: Cumulative count of leaf-level deletes | MSSLEAFDELCNT | DEC | 15 | |||||
LEAF_UPDATE_COUNT | Index op stats: Cumulative count of leaf-level updates | MSSLEAFUPDCNT | DEC | 15 | |||||
LEAF_GHOST_COUNT | Index op stats: Count of leaf-level rows marked for delete | MSSLEAFGHOSTCNT | DEC | 15 | |||||
NONLEAF_INSERT_COUNT | Index op stats: Count of inserts above the leaf level | MSSNONLEAFINSCNT | DEC | 15 | |||||
NONLEAF_DELETE_COUNT | Index op stats: Count of deletes above the leaf level | MSSNONLEAFDELCNT | DEC | 15 | |||||
NONLEAF_UPDATE_COUNT | Index op stats: Count of updates above the leaf level | MSSNONLEAFUPDCNT | DEC | 15 | |||||
LEAF_ALLOCATION_COUNT | Index op stats: Count of leaf-level page allocations | MSSLEAFALLOCCNT | DEC | 15 | |||||
NONLEAF_ALLOCATION_COUNT | Index op stats: Count of non leaf-level page allocations | MSSNONLEAFALLOCCNT | DEC | 15 | |||||
LEAF_PAGE_MERGE_COUNT | Index op stats: Count of page merges at the leaf level | MSSLEAFPAGEMERGECNT | DEC | 15 | |||||
NONLEAF_PAGE_MERGE_COUNT | Index op stats: Count of page merges above the leaf level | MSSNONLEAFPAGEMERGECNT | DEC | 15 | |||||
RANGE_SCAN_COUNT | Index op stats: Count of range and table scans | MSSRANGESCANCNT | DEC | 15 | |||||
SINGLETON_LOOKUP_COUNT | Index op stats: Count of single row retrievals | MSSSINGLETONLOOKUPCNT | DEC | 15 | |||||
FORWARDED_FETCH_COUNT | Index op stats: Rows fetched through a forwarding record | MSSFORWARDEDFTCHCNT | DEC | 15 | |||||
LOB_FETCH_IN_PAGES | Index op stats: Lob fetch pages | MSSLOBFTCHINPAGES | DEC | 15 | |||||
LOB_FETCH_IN_BYTES | Index op stats: Count of LOB data bytes retrieved | MSSLOBFTCHINBYTES | DEC | 15 | |||||
LOB_ORPHAN_CREATE_COUNT | Index op stats: Count of orphan LOB created | MSSLOBORPHANCREATECNT | DEC | 15 | |||||
LOB_ORPHAN_INSERT_COUNT | Index op stats:Orphan LOB values inserted during bulkop | MSSLOBORPHANINSCNT | DEC | 15 | |||||
ROW_OVERFLOW_FETCH_IN_PAGES | Index op stats: Data pages from ROW_OVERFLOW_DATA | MSSROWOVERFLOWFTCHINPAGES | DEC | 15 | |||||
ROW_OVERFLOW_FETCH_IN_BYTES | Index op stats: Data bytes from ROW_OVERFLOW_DATA | MSSROWOVERFLOWFTCHINBYTES | DEC | 15 | |||||
COLUMN_VALUE_PUSH_OFF_ROW_COUN | Index op stats: Count of values pushed off-row for a new row | MSSCOLUMNVALUEPUSHOFFROWCNT | DEC | 15 | |||||
COLUMN_VALUE_PULL_IN_ROW_COUNT | Index op stats: Count of values pulled in-row | MSSCOLUMNVALUEPULLINROWCNT | DEC | 15 | |||||
ROW_LOCK_COUNT | Index op stats: Count of row locks requested | MSSROWLCKCNT | DEC | 15 | |||||
ROW_LOCK_WAIT_COUNT | Index op stats: Count of row lock waits | MSSROWLCKWAITCNT | DEC | 15 | |||||
ROW_LOCK_WAIT_IN_MS | Index op stats: Row lock waits in ms | MSSROWLCKWAITMS | DEC | 15 | |||||
PAGE_LOCK_COUNT | Index op stats: Page lock count | MSSPAGELCKCNT | DEC | 15 | |||||
PAGE_LOCK_WAIT_COUNT | Index op stats: Page lock wait count | MSSPAGELCKWAITCNT | DEC | 15 | |||||
PAGE_LOCK_WAIT_IN_MS | Index op stats: Page lock wait in milliseconds | MSSPAGELCKWAITMS | DEC | 15 | |||||
INDEX_LOCK_PROMOTION_ATTEMPT_C | Index op stats: Index lock promotion attempts | MSSINDEXLCKPROMOTIONATTEMPTCNT | DEC | 15 | |||||
INDEX_LOCK_PROMOTION_COUNT | Index op stats: Index lock promotions | MSSINDEXLCKPROMOTIONCNT | DEC | 15 | |||||
PAGE_LATCH_WAIT_COUNT | Index op stats: Latch wait count | MSSPAGELTCHWAITCNT | DEC | 15 | |||||
PAGE_LATCH_WAIT_IN_MS | Index op stats: Latch waits ms | MSSPAGELTCHWAITMS | DEC | 15 | |||||
PAGE_IO_LATCH_WAIT_COUNT | Index op stats: I/O page latch wait count | MSSPAGEIOLTCHWAITCNT | DEC | 15 | |||||
PAGE_IO_LATCH_WAIT_IN_MS | Index op stats: I/O page latch wait in ms | MSSPAGEIOLTCHWAITMS | DEC | 15 | |||||
TOTAL_LL_TIME | Total lock/latch wait time | MSSTOTLLTIME | DEC | 15 | |||||
TOTAL_LL_COUNT | Total lock or latch wait events | MSSTOTLLCOUNT | DEC | 15 | |||||
AVG_TOTAL_LL_WAIT | Average wait for a latch or a lock | MSSAVGTOTLLWAIT | DEC | 15 |
Key field | Non-key field |
How do I retrieve data from SAP structure MSSIDXOPSTATS using ABAP code?
As MSSIDXOPSTATS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MSSIDXOPSTATS as there is no data to select.How to access SAP table MSSIDXOPSTATS
Within an ECC or HANA version of SAP you can also view further information about MSSIDXOPSTATS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects