SAP /SDF/MSSINDEXSTATS table - SQL Server: Index size and usage (copy of MSDINDSTAT) details in SAP

SAP /SDF/MSSINDEXSTATS table summary

Object Name: /SDF/MSSINDEXSTATS
Dictionary Type: Structure
Description: SQL Server: Index size and usage (copy of MSDINDSTAT)

Field list for /SDF/MSSINDEXSTATS table on an S/4 SAP system

Details

/SDF/MSSINDEXSTATS-ANLYID table field - SQL Server analysis ID for statement download ▼

Description: SQL Server analysis ID for statement download
Field Name: ANLYID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANLYID

/SDF/MSSINDEXSTATS-TABNAME table field - SQL Server table or index name ▼

Description: SQL Server table or index name
Field Name: TABNAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABNAME

/SDF/MSSINDEXSTATS-IDXNAME table field - SQL Server index name ble ▼

Description: SQL Server index name ble
Field Name: IDXNAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDXNAME

/SDF/MSSINDEXSTATS-DDIDXNAME table field - SQL Server SAP index name table ▼

Description: SQL Server SAP index name table
Field Name: DDIDXNAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DDIDXNAME

/SDF/MSSINDEXSTATS-IDXDESC table field - SQL Server index description ndexes ▼

Description: SQL Server index description ndexes
Field Name: IDXDESC
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDXDESC

/SDF/MSSINDEXSTATS-IDXKEYS table field - SQL Server table index details ▼

Description: SQL Server table index details
Field Name: IDXKEYS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDXKEYS

/SDF/MSSINDEXSTATS-IDXHGT table field - SQL Server height of the index table ▼

Description: SQL Server height of the index table
Field Name: IDXHGT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDXHGT

/SDF/MSSINDEXSTATS-ROWMINLEN table field - SQL server minimum size of the row ▼

Description: SQL server minimum size of the row
Field Name: ROWMINLEN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWMINLEN

/SDF/MSSINDEXSTATS-ROWMAXLEN table field - SQL Server maximum size of a row ▼

Description: SQL Server maximum size of a row
Field Name: ROWMAXLEN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWMAXLEN

/SDF/MSSINDEXSTATS-ROWMODCTR table field - SQL Server modified rows in the table ▼

Description: SQL Server modified rows in the table
Field Name: ROWMODCTR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWMODCTR

/SDF/MSSINDEXSTATS-AUTOUPDFLG table field - SQL Server auto update flag of index ▼

Description: SQL Server auto update flag of index
Field Name: AUTOUPDFLG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOUPDFLG

/SDF/MSSINDEXSTATS-UPDDATE table field - SQL Server last update statistics date ▼

Description: SQL Server last update statistics date
Field Name: UPDDATE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UPDDATE

/SDF/MSSINDEXSTATS-TOTALROWS table field - SQL Server number of rows in a table ▼

Description: SQL Server number of rows in a table
Field Name: TOTALROWS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTALROWS

/SDF/MSSINDEXSTATS-ROWSAMPLED table field - SQL Server statement download rows sampled for stats ▼

Description: SQL Server statement download rows sampled for stats
Field Name: ROWSAMPLED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWSAMPLED

/SDF/MSSINDEXSTATS-STEPS table field - SQL Server statement download number of histogram steps ▼

Description: SQL Server statement download number of histogram steps
Field Name: STEPS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STEPS

/SDF/MSSINDEXSTATS-DENSITY table field - SQL Server statement download column selectivity value ▼

Description: SQL Server statement download column selectivity value
Field Name: DENSITY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DENSITY

/SDF/MSSINDEXSTATS-AVGKEYLEN table field - SQL Server index statistics avg. key length ▼

Description: SQL Server index statistics avg. key length
Field Name: AVGKEYLEN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGKEYLEN

/SDF/MSSINDEXSTATS-ALLDENSITY table field - SQL Server column density number of gen buffered fields ▼

Description: SQL Server column density number of gen buffered fields
Field Name: ALLDENSITY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALLDENSITY

/SDF/MSSINDEXSTATS-ALLDENSCOL table field - SQL Server statement download index field ▼

Description: SQL Server statement download index field
Field Name: ALLDENSCOL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALLDENSCOL

View list of all SAP tables(S4H/ECC)

Select data from SAP table