SAP MSSIDXOPSTATS table - Index operational stats output from MSS_GET_INDEX_OP_STATS details in SAP

SAP MSSIDXOPSTATS table summary

Object Name: MSSIDXOPSTATS
Dictionary Type: Structure
Description: Index operational stats output from MSS_GET_INDEX_OP_STATS

Field list for MSSIDXOPSTATS table on an S/4 SAP system

Details

MSSIDXOPSTATS-DBNAME table field - Database name ▼

Description: Database name
Field Name: DBNAME
Data Element: MSSDB
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSSIDXOPSTATS-SCHEMANAME table field - Schema name ▼

Description: Schema name
Field Name: SCHEMANAME
Data Element: MSSSCHEMA
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHEMANAME

MSSIDXOPSTATS-TABNAME table field - Table name ▼

Description: Table name
Field Name: TABNAME
Data Element: MSSTABLE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABNAME

MSSIDXOPSTATS-INDEXNAME table field - Index name ▼

Description: Index name
Field Name: INDEXNAME
Data Element: MSSINDEX
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXNAME

MSSIDXOPSTATS-TOTAL_OPS table field - Index op stats: Total operations on the index ▼

Description: Index op stats: Total operations on the index
Field Name: TOTAL_OPS
Data Element: MSSIDXOPTOTALOPS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_OPS

MSSIDXOPSTATS-AVPGIOLTCHWAIT table field - Average page io latch wait ▼

Description: Average page io latch wait
Field Name: AVPGIOLTCHWAIT
Data Element: MSSAVPGIOLTCHWAIT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVPGIOLTCHWAIT

MSSIDXOPSTATS-AVGPGLTCHWAIT table field - Average page latch wait ms ▼

Description: Average page latch wait ms
Field Name: AVGPGLTCHWAIT
Data Element: MSSAVGPGLTCHWAIT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGPGLTCHWAIT

MSSIDXOPSTATS-AVGROWLCKWAIT table field - Average rowlock wait ms ▼

Description: Average rowlock wait ms
Field Name: AVGROWLCKWAIT
Data Element: MSSAVGROWLCKWAIT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGROWLCKWAIT

MSSIDXOPSTATS-AVGPGLCKWAIT table field - Average pagelock wait ms ▼

Description: Average pagelock wait ms
Field Name: AVGPGLCKWAIT
Data Element: MSSAVGPGLCKWAIT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGPGLCKWAIT

MSSIDXOPSTATS-LEAF_INSERT_COUNT table field - Index op stats: Cumulative count of leaf-level inserts ▼

Description: Index op stats: Cumulative count of leaf-level inserts
Field Name: LEAF_INSERT_COUNT
Data Element: MSSLEAFINSCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAF_INSERT_COUNT

MSSIDXOPSTATS-LEAF_DELETE_COUNT table field - Index op stats: Cumulative count of leaf-level deletes ▼

Description: Index op stats: Cumulative count of leaf-level deletes
Field Name: LEAF_DELETE_COUNT
Data Element: MSSLEAFDELCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAF_DELETE_COUNT

MSSIDXOPSTATS-LEAF_UPDATE_COUNT table field - Index op stats: Cumulative count of leaf-level updates ▼

Description: Index op stats: Cumulative count of leaf-level updates
Field Name: LEAF_UPDATE_COUNT
Data Element: MSSLEAFUPDCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAF_UPDATE_COUNT

MSSIDXOPSTATS-LEAF_GHOST_COUNT table field - Index op stats: Count of leaf-level rows marked for delete ▼

Description: Index op stats: Count of leaf-level rows marked for delete
Field Name: LEAF_GHOST_COUNT
Data Element: MSSLEAFGHOSTCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAF_GHOST_COUNT

MSSIDXOPSTATS-NONLEAF_INSERT_COUNT table field - Index op stats: Count of inserts above the leaf level ▼

Description: Index op stats: Count of inserts above the leaf level
Field Name: NONLEAF_INSERT_COUNT
Data Element: MSSNONLEAFINSCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NONLEAF_INSERT_COUNT

MSSIDXOPSTATS-NONLEAF_DELETE_COUNT table field - Index op stats: Count of deletes above the leaf level ▼

Description: Index op stats: Count of deletes above the leaf level
Field Name: NONLEAF_DELETE_COUNT
Data Element: MSSNONLEAFDELCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NONLEAF_DELETE_COUNT

MSSIDXOPSTATS-NONLEAF_UPDATE_COUNT table field - Index op stats: Count of updates above the leaf level ▼

Description: Index op stats: Count of updates above the leaf level
Field Name: NONLEAF_UPDATE_COUNT
Data Element: MSSNONLEAFUPDCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NONLEAF_UPDATE_COUNT

MSSIDXOPSTATS-LEAF_ALLOCATION_COUNT table field - Index op stats: Count of leaf-level page allocations ▼

Description: Index op stats: Count of leaf-level page allocations
Field Name: LEAF_ALLOCATION_COUNT
Data Element: MSSLEAFALLOCCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAF_ALLOCATION_COUNT

MSSIDXOPSTATS-NONLEAF_ALLOCATION_COUNT table field - Index op stats: Count of non leaf-level page allocations ▼

Description: Index op stats: Count of non leaf-level page allocations
Field Name: NONLEAF_ALLOCATION_COUNT
Data Element: MSSNONLEAFALLOCCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NONLEAF_ALLOCATION_COUNT

MSSIDXOPSTATS-LEAF_PAGE_MERGE_COUNT table field - Index op stats: Count of page merges at the leaf level ▼

Description: Index op stats: Count of page merges at the leaf level
Field Name: LEAF_PAGE_MERGE_COUNT
Data Element: MSSLEAFPAGEMERGECNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAF_PAGE_MERGE_COUNT

MSSIDXOPSTATS-NONLEAF_PAGE_MERGE_COUNT table field - Index op stats: Count of page merges above the leaf level ▼

Description: Index op stats: Count of page merges above the leaf level
Field Name: NONLEAF_PAGE_MERGE_COUNT
Data Element: MSSNONLEAFPAGEMERGECNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NONLEAF_PAGE_MERGE_COUNT

MSSIDXOPSTATS-RANGE_SCAN_COUNT table field - Index op stats: Count of range and table scans ▼

Description: Index op stats: Count of range and table scans
Field Name: RANGE_SCAN_COUNT
Data Element: MSSRANGESCANCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RANGE_SCAN_COUNT

MSSIDXOPSTATS-SINGLETON_LOOKUP_COUNT table field - Index op stats: Count of single row retrievals ▼

Description: Index op stats: Count of single row retrievals
Field Name: SINGLETON_LOOKUP_COUNT
Data Element: MSSSINGLETONLOOKUPCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SINGLETON_LOOKUP_COUNT

MSSIDXOPSTATS-FORWARDED_FETCH_COUNT table field - Index op stats: Rows fetched through a forwarding record ▼

Description: Index op stats: Rows fetched through a forwarding record
Field Name: FORWARDED_FETCH_COUNT
Data Element: MSSFORWARDEDFTCHCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FORWARDED_FETCH_COUNT

MSSIDXOPSTATS-LOB_FETCH_IN_PAGES table field - Index op stats: Lob fetch pages ▼

Description: Index op stats: Lob fetch pages
Field Name: LOB_FETCH_IN_PAGES
Data Element: MSSLOBFTCHINPAGES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOB_FETCH_IN_PAGES

MSSIDXOPSTATS-LOB_FETCH_IN_BYTES table field - Index op stats: Count of LOB data bytes retrieved ▼

Description: Index op stats: Count of LOB data bytes retrieved
Field Name: LOB_FETCH_IN_BYTES
Data Element: MSSLOBFTCHINBYTES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOB_FETCH_IN_BYTES

MSSIDXOPSTATS-LOB_ORPHAN_CREATE_COUNT table field - Index op stats: Count of orphan LOB created ▼

Description: Index op stats: Count of orphan LOB created
Field Name: LOB_ORPHAN_CREATE_COUNT
Data Element: MSSLOBORPHANCREATECNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOB_ORPHAN_CREATE_COUNT

MSSIDXOPSTATS-LOB_ORPHAN_INSERT_COUNT table field - Index op stats:Orphan LOB values inserted during bulkop ▼

Description: Index op stats:Orphan LOB values inserted during bulkop
Field Name: LOB_ORPHAN_INSERT_COUNT
Data Element: MSSLOBORPHANINSCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOB_ORPHAN_INSERT_COUNT

MSSIDXOPSTATS-ROW_OVERFLOW_FETCH_IN_PAGES table field - Index op stats: Data pages from ROW_OVERFLOW_DATA ▼

Description: Index op stats: Data pages from ROW_OVERFLOW_DATA
Field Name: ROW_OVERFLOW_FETCH_IN_PAGES
Data Element: MSSROWOVERFLOWFTCHINPAGES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROW_OVERFLOW_FETCH_IN_PAGES

MSSIDXOPSTATS-ROW_OVERFLOW_FETCH_IN_BYTES table field - Index op stats: Data bytes from ROW_OVERFLOW_DATA ▼

Description: Index op stats: Data bytes from ROW_OVERFLOW_DATA
Field Name: ROW_OVERFLOW_FETCH_IN_BYTES
Data Element: MSSROWOVERFLOWFTCHINBYTES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROW_OVERFLOW_FETCH_IN_BYTES

MSSIDXOPSTATS-COLUMN_VALUE_PUSH_OFF_ROW_COUN table field - Index op stats: Count of values pushed off-row for a new row ▼

Description: Index op stats: Count of values pushed off-row for a new row
Field Name: COLUMN_VALUE_PUSH_OFF_ROW_COUN
Data Element: MSSCOLUMNVALUEPUSHOFFROWCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLUMN_VALUE_PUSH_OFF_ROW_COUN

MSSIDXOPSTATS-COLUMN_VALUE_PULL_IN_ROW_COUNT table field - Index op stats: Count of values pulled in-row ▼

Description: Index op stats: Count of values pulled in-row
Field Name: COLUMN_VALUE_PULL_IN_ROW_COUNT
Data Element: MSSCOLUMNVALUEPULLINROWCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLUMN_VALUE_PULL_IN_ROW_COUNT

MSSIDXOPSTATS-ROW_LOCK_COUNT table field - Index op stats: Count of row locks requested ▼

Description: Index op stats: Count of row locks requested
Field Name: ROW_LOCK_COUNT
Data Element: MSSROWLCKCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROW_LOCK_COUNT

MSSIDXOPSTATS-ROW_LOCK_WAIT_COUNT table field - Index op stats: Count of row lock waits ▼

Description: Index op stats: Count of row lock waits
Field Name: ROW_LOCK_WAIT_COUNT
Data Element: MSSROWLCKWAITCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROW_LOCK_WAIT_COUNT

MSSIDXOPSTATS-ROW_LOCK_WAIT_IN_MS table field - Index op stats: Row lock waits in ms ▼

Description: Index op stats: Row lock waits in ms
Field Name: ROW_LOCK_WAIT_IN_MS
Data Element: MSSROWLCKWAITMS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROW_LOCK_WAIT_IN_MS

MSSIDXOPSTATS-PAGE_LOCK_COUNT table field - Index op stats: Page lock count ▼

Description: Index op stats: Page lock count
Field Name: PAGE_LOCK_COUNT
Data Element: MSSPAGELCKCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGE_LOCK_COUNT

MSSIDXOPSTATS-PAGE_LOCK_WAIT_COUNT table field - Index op stats: Page lock wait count ▼

Description: Index op stats: Page lock wait count
Field Name: PAGE_LOCK_WAIT_COUNT
Data Element: MSSPAGELCKWAITCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGE_LOCK_WAIT_COUNT

MSSIDXOPSTATS-PAGE_LOCK_WAIT_IN_MS table field - Index op stats: Page lock wait in milliseconds ▼

Description: Index op stats: Page lock wait in milliseconds
Field Name: PAGE_LOCK_WAIT_IN_MS
Data Element: MSSPAGELCKWAITMS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGE_LOCK_WAIT_IN_MS

MSSIDXOPSTATS-INDEX_LOCK_PROMOTION_ATTEMPT_C table field - Index op stats: Index lock promotion attempts ▼

Description: Index op stats: Index lock promotion attempts
Field Name: INDEX_LOCK_PROMOTION_ATTEMPT_C
Data Element: MSSINDEXLCKPROMOTIONATTEMPTCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEX_LOCK_PROMOTION_ATTEMPT_C

MSSIDXOPSTATS-INDEX_LOCK_PROMOTION_COUNT table field - Index op stats: Index lock promotions ▼

Description: Index op stats: Index lock promotions
Field Name: INDEX_LOCK_PROMOTION_COUNT
Data Element: MSSINDEXLCKPROMOTIONCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEX_LOCK_PROMOTION_COUNT

MSSIDXOPSTATS-PAGE_LATCH_WAIT_COUNT table field - Index op stats: Latch wait count ▼

Description: Index op stats: Latch wait count
Field Name: PAGE_LATCH_WAIT_COUNT
Data Element: MSSPAGELTCHWAITCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGE_LATCH_WAIT_COUNT

MSSIDXOPSTATS-PAGE_LATCH_WAIT_IN_MS table field - Index op stats: Latch waits ms ▼

Description: Index op stats: Latch waits ms
Field Name: PAGE_LATCH_WAIT_IN_MS
Data Element: MSSPAGELTCHWAITMS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGE_LATCH_WAIT_IN_MS

MSSIDXOPSTATS-PAGE_IO_LATCH_WAIT_COUNT table field - Index op stats: I/O page latch wait count ▼

Description: Index op stats: I/O page latch wait count
Field Name: PAGE_IO_LATCH_WAIT_COUNT
Data Element: MSSPAGEIOLTCHWAITCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGE_IO_LATCH_WAIT_COUNT

MSSIDXOPSTATS-PAGE_IO_LATCH_WAIT_IN_MS table field - Index op stats: I/O page latch wait in ms ▼

Description: Index op stats: I/O page latch wait in ms
Field Name: PAGE_IO_LATCH_WAIT_IN_MS
Data Element: MSSPAGEIOLTCHWAITMS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGE_IO_LATCH_WAIT_IN_MS

MSSIDXOPSTATS-TOTAL_LL_TIME table field - Total lock/latch wait time ▼

Description: Total lock/latch wait time
Field Name: TOTAL_LL_TIME
Data Element: MSSTOTLLTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_LL_TIME

MSSIDXOPSTATS-TOTAL_LL_COUNT table field - Total lock or latch wait events ▼

Description: Total lock or latch wait events
Field Name: TOTAL_LL_COUNT
Data Element: MSSTOTLLCOUNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_LL_COUNT

MSSIDXOPSTATS-AVG_TOTAL_LL_WAIT table field - Average wait for a latch or a lock ▼

Description: Average wait for a latch or a lock
Field Name: AVG_TOTAL_LL_WAIT
Data Element: MSSAVGTOTLLWAIT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_TOTAL_LL_WAIT

View list of all SAP tables(S4H/ECC)

Select data from SAP table