SAP MSQIDXDETS table - MS SQL server - Index details & statistics details in SAP
SAP MSQIDXDETS table summary
Object Name: MSQIDXDETS Dictionary Type: Structure Description: MS SQL server - Index details & statistics
Field list for MSQIDXDETS table on an S/4 SAP system
Details
MSQIDXDETS-IDXNAME table field - MS SQL server table or index name ▼
Description: MS SQL server table or index name Field Name: IDXNAME Data Element: MSQTABNAME Data Type: length (Dec): 0(0) Check table: Conversion Routine: Domain Name: MemoryID: AppClass: SHLP: SHLP Field: ConvExit:
MSQIDXDETS-IDXKEYS table field - The table columns in the index key. ▼
Description: The table columns in the index key. Field Name: IDXKEYS Data Element: MSQINDKEYS Data Type: length (Dec): 0(0) Check table: Conversion Routine: Domain Name: MemoryID: AppClass: SHLP: SHLP Field: ConvExit:
MSQIDXDETS-IDXHGT table field - Number of index levels excluding data pages (index height). ▼
Description: Number of index levels excluding data pages (index height). Field Name: IDXHGT Data Element: MSQIDXHGT Data Type: length (Dec): 0(0) Check table: Conversion Routine: Domain Name: MemoryID: AppClass: SHLP: SHLP Field: ConvExit:
MSQIDXDETS-ROWMINLEN table field - MS SQL server minimum size of the row. ▼
Description: MS SQL server minimum size of the row. Field Name: ROWMINLEN Data Element: MSQMINLEN Data Type: length (Dec): 0(0) Check table: Conversion Routine: Domain Name: MemoryID: AppClass: SHLP: SHLP Field: ConvExit:
MSQIDXDETS-ROWMAXLEN table field - MS SQL server - maximum size of a row ▼
Description: MS SQL server - maximum size of a row Field Name: ROWMAXLEN Data Element: MSQMAXLEN Data Type: length (Dec): 0(0) Check table: Conversion Routine: Domain Name: MemoryID: AppClass: SHLP: SHLP Field: ConvExit:
MSQIDXDETS-ROWMODCTR table field - MS SQL server - modified rows in the table since upd stats ▼
Description: MS SQL server - modified rows in the table since upd stats Field Name: ROWMODCTR Data Element: MSQMODROWS Data Type: length (Dec): 0(0) Check table: Conversion Routine: Domain Name: MemoryID: AppClass: SHLP: SHLP Field: ConvExit:
MSQIDXDETS-AUTOUPDFLG table field - SQL Server flag for auto update statistics for table index. ▼
Description: SQL Server flag for auto update statistics for table index. Field Name: AUTOUPDFLG Data Element: MSQAUTOUPD Data Type: length (Dec): 0(0) Check table: Conversion Routine: Domain Name: MemoryID: AppClass: SHLP: SHLP Field: ConvExit:
MSQIDXDETS-UPDDATE table field - Last time the index statistics was updated. ▼
Description: Last time the index statistics was updated. Field Name: UPDDATE Data Element: MSQLSTUPST Data Type: length (Dec): 0(0) Check table: Conversion Routine: Domain Name: MemoryID: AppClass: SHLP: SHLP Field: ConvExit: