SAP MSQSHCONTG table - Displays fragmentation info for data and indexes of a table details in SAP

SAP MSQSHCONTG table summary

Object Name: MSQSHCONTG
Dictionary Type: Structure
Description: Displays fragmentation info for data and indexes of a table

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

Details

MSQSHCONTG-OBJNAME table field - Table or index name. ▼

Description: Table or index name.
Field Name: OBJNAME
Data Element: MSQOBTNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJNAME

MSQSHCONTG-OBJID table field - SQL Server object or index ID. ▼

Description: SQL Server object or index ID.
Field Name: OBJID
Data Element: MSQOBJID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJID

MSQSHCONTG-INDEXNAME table field - Table or index name. ▼

Description: Table or index name.
Field Name: INDEXNAME
Data Element: MSQOBTNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXNAME

MSQSHCONTG-INDEXID table field - SQL Server object or index ID. ▼

Description: SQL Server object or index ID.
Field Name: INDEXID
Data Element: MSQOBJID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXID

MSQSHCONTG-INDEXLEVEL table field - Level within the index tree - 0 is the leaf (or data) level. ▼

Description: Level within the index tree - 0 is the leaf (or data) level.
Field Name: INDEXLEVEL
Data Element: MSQIDXLEVL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXLEVEL

MSQSHCONTG-CNTPAGES table field - No. of pages in the index level. ▼

Description: No. of pages in the index level.
Field Name: CNTPAGES
Data Element: MSQIDXPAGS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CNTPAGES

MSQSHCONTG-CNTROWS table field - No. of rows in that level of the index. ▼

Description: No. of rows in that level of the index.
Field Name: CNTROWS
Data Element: MSQIDXROWS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CNTROWS

MSQSHCONTG-MINRECSIZE table field - Minimum record size in that level of the index. ▼

Description: Minimum record size in that level of the index.
Field Name: MINRECSIZE
Data Element: MSSMINRCSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MINRECSIZE

MSQSHCONTG-MAXRECSIZE table field - Maximum record size in that level of the index. ▼

Description: Maximum record size in that level of the index.
Field Name: MAXRECSIZE
Data Element: MSSMAXRCSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXRECSIZE

MSQSHCONTG-AVGRECSIZE table field - Average record size (byte). ▼

Description: Average record size (byte).
Field Name: AVGRECSIZE
Data Element: MSQAVRWSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGRECSIZE

MSQSHCONTG-FORWARDREC table field - No. of forwarded records in that index level or entire heap. ▼

Description: No. of forwarded records in that index level or entire heap.
Field Name: FORWARDREC
Data Element: MSQIXFORRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FORWARDREC

MSQSHCONTG-EXTENTS table field - No. of extents in that index level or entire heap. ▼

Description: No. of extents in that index level or entire heap.
Field Name: EXTENTS
Data Element: MSQIDXEXTS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENTS

MSQSHCONTG-EXTSWITCH table field - No. of extent switches by traversing the index level. ▼

Description: No. of extent switches by traversing the index level.
Field Name: EXTSWITCH
Data Element: MSQEXTSWIT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTSWITCH

MSQSHCONTG-AVGFRBYTES table field - Average number of free bytes on the pages scanned. ▼

Description: Average number of free bytes on the pages scanned.
Field Name: AVGFRBYTES
Data Element: MSQAVFRBYT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGFRBYTES

MSQSHCONTG-AVGPGDENS table field - Average page density as percentage (the higher, the better). ▼

Description: Average page density as percentage (the higher, the better).
Field Name: AVGPGDENS
Data Element: MSQAVPGDEN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGPGDENS

MSQSHCONTG-SCANDNSITY table field - Scan density of extents (100% is the best value). ▼

Description: Scan density of extents (100% is the best value).
Field Name: SCANDNSITY
Data Element: MSQSCANDEN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCANDNSITY

MSQSHCONTG-BESTEXTCNT table field - Ideal no. of extent changes if all are contiguously linked. ▼

Description: Ideal no. of extent changes if all are contiguously linked.
Field Name: BESTEXTCNT
Data Element: MSQBESTEXT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BESTEXTCNT

MSQSHCONTG-ACTEXTCNT table field - Number of extents scanned ( = extent switches +1). ▼

Description: Number of extents scanned ( = extent switches +1).
Field Name: ACTEXTCNT
Data Element: MSQACTEXCT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTEXTCNT

MSQSHCONTG-LOGIFRAG table field - Logical fragmentation in leaf-pages of an index. ▼

Description: Logical fragmentation in leaf-pages of an index.
Field Name: LOGIFRAG
Data Element: MSQLOGFRAG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGIFRAG

MSQSHCONTG-EXTFRAG table field - Extent fragmentation in scanning the leaf pages of an index ▼

Description: Extent fragmentation in scanning the leaf pages of an index
Field Name: EXTFRAG
Data Element: MSQEXTFRAG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTFRAG

View list of all SAP tables(S4H/ECC)

Select data from SAP table