MSSIDXOPSTATS SAP (Index operational stats output from MSS_GET_INDEX_OP_STATS) Structure details

Dictionary Type: Structure
Description: Index operational stats output from MSS_GET_INDEX_OP_STATS




ABAP Code to SELECT data from MSSIDXOPSTATS
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
DBNAMEDatabase name MSSDBCHAR128MSSSYSNAME
SCHEMANAMESchema name MSSSCHEMACHAR128MSSSYSNAME
TABNAMETable name MSSTABLECHAR128MSSSYSNAME
INDEXNAMEIndex name MSSINDEXCHAR128MSSSYSNAME
TOTAL_OPSIndex op stats: Total operations on the index MSSIDXOPTOTALOPSDEC15
AVPGIOLTCHWAITAverage page io latch wait MSSAVPGIOLTCHWAITDEC15(3)
AVGPGLTCHWAITAverage page latch wait ms MSSAVGPGLTCHWAITDEC15(3)
AVGROWLCKWAITAverage rowlock wait ms MSSAVGROWLCKWAITDEC15(3)
AVGPGLCKWAITAverage pagelock wait ms MSSAVGPGLCKWAITDEC15(3)
LEAF_INSERT_COUNTIndex op stats: Cumulative count of leaf-level inserts MSSLEAFINSCNTDEC15
LEAF_DELETE_COUNTIndex op stats: Cumulative count of leaf-level deletes MSSLEAFDELCNTDEC15
LEAF_UPDATE_COUNTIndex op stats: Cumulative count of leaf-level updates MSSLEAFUPDCNTDEC15
LEAF_GHOST_COUNTIndex op stats: Count of leaf-level rows marked for delete MSSLEAFGHOSTCNTDEC15
NONLEAF_INSERT_COUNTIndex op stats: Count of inserts above the leaf level MSSNONLEAFINSCNTDEC15
NONLEAF_DELETE_COUNTIndex op stats: Count of deletes above the leaf level MSSNONLEAFDELCNTDEC15
NONLEAF_UPDATE_COUNTIndex op stats: Count of updates above the leaf level MSSNONLEAFUPDCNTDEC15
LEAF_ALLOCATION_COUNTIndex op stats: Count of leaf-level page allocations MSSLEAFALLOCCNTDEC15
NONLEAF_ALLOCATION_COUNTIndex op stats: Count of non leaf-level page allocations MSSNONLEAFALLOCCNTDEC15
LEAF_PAGE_MERGE_COUNTIndex op stats: Count of page merges at the leaf level MSSLEAFPAGEMERGECNTDEC15
NONLEAF_PAGE_MERGE_COUNTIndex op stats: Count of page merges above the leaf level MSSNONLEAFPAGEMERGECNTDEC15
RANGE_SCAN_COUNTIndex op stats: Count of range and table scans MSSRANGESCANCNTDEC15
SINGLETON_LOOKUP_COUNTIndex op stats: Count of single row retrievals MSSSINGLETONLOOKUPCNTDEC15
FORWARDED_FETCH_COUNTIndex op stats: Rows fetched through a forwarding record MSSFORWARDEDFTCHCNTDEC15
LOB_FETCH_IN_PAGESIndex op stats: Lob fetch pages MSSLOBFTCHINPAGESDEC15
LOB_FETCH_IN_BYTESIndex op stats: Count of LOB data bytes retrieved MSSLOBFTCHINBYTESDEC15
LOB_ORPHAN_CREATE_COUNTIndex op stats: Count of orphan LOB created MSSLOBORPHANCREATECNTDEC15
LOB_ORPHAN_INSERT_COUNTIndex op stats:Orphan LOB values inserted during bulkop MSSLOBORPHANINSCNTDEC15
ROW_OVERFLOW_FETCH_IN_PAGESIndex op stats: Data pages from ROW_OVERFLOW_DATA MSSROWOVERFLOWFTCHINPAGESDEC15
ROW_OVERFLOW_FETCH_IN_BYTESIndex op stats: Data bytes from ROW_OVERFLOW_DATA MSSROWOVERFLOWFTCHINBYTESDEC15
COLUMN_VALUE_PUSH_OFF_ROW_COUNIndex op stats: Count of values pushed off-row for a new row MSSCOLUMNVALUEPUSHOFFROWCNTDEC15
COLUMN_VALUE_PULL_IN_ROW_COUNTIndex op stats: Count of values pulled in-row MSSCOLUMNVALUEPULLINROWCNTDEC15
ROW_LOCK_COUNTIndex op stats: Count of row locks requested MSSROWLCKCNTDEC15
ROW_LOCK_WAIT_COUNTIndex op stats: Count of row lock waits MSSROWLCKWAITCNTDEC15
ROW_LOCK_WAIT_IN_MSIndex op stats: Row lock waits in ms MSSROWLCKWAITMSDEC15
PAGE_LOCK_COUNTIndex op stats: Page lock count MSSPAGELCKCNTDEC15
PAGE_LOCK_WAIT_COUNTIndex op stats: Page lock wait count MSSPAGELCKWAITCNTDEC15
PAGE_LOCK_WAIT_IN_MSIndex op stats: Page lock wait in milliseconds MSSPAGELCKWAITMSDEC15
INDEX_LOCK_PROMOTION_ATTEMPT_CIndex op stats: Index lock promotion attempts MSSINDEXLCKPROMOTIONATTEMPTCNTDEC15
INDEX_LOCK_PROMOTION_COUNTIndex op stats: Index lock promotions MSSINDEXLCKPROMOTIONCNTDEC15
PAGE_LATCH_WAIT_COUNTIndex op stats: Latch wait count MSSPAGELTCHWAITCNTDEC15
PAGE_LATCH_WAIT_IN_MSIndex op stats: Latch waits ms MSSPAGELTCHWAITMSDEC15
PAGE_IO_LATCH_WAIT_COUNTIndex op stats: I/O page latch wait count MSSPAGEIOLTCHWAITCNTDEC15
PAGE_IO_LATCH_WAIT_IN_MSIndex op stats: I/O page latch wait in ms MSSPAGEIOLTCHWAITMSDEC15
TOTAL_LL_TIMETotal lock/latch wait time MSSTOTLLTIMEDEC15
TOTAL_LL_COUNTTotal lock or latch wait events MSSTOTLLCOUNTDEC15
AVG_TOTAL_LL_WAITAverage wait for a latch or a lock MSSAVGTOTLLWAITDEC15

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!