SAP INDEX_STAT table - index_stats Cache: Result of VALIDATE Index (Oracle) details in SAP

SAP INDEX_STAT table summary

Object Name: INDEX_STAT
Dictionary Type: Transparent table
Description: index_stats Cache: Result of VALIDATE Index (Oracle)

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

Details

INDEX_STAT-NAME table field - Object: Name of table or index ▼

Description: Object: Name of table or index
Field Name: NAME
Data Element: DB_OBJECT
Data Type: CHAR
length (Dec): 81(0)
Check table:
Conversion Routine:
Domain Name: CHAR81
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

INDEX_STAT-DATUM table field - Date ▼

Description: Date
Field Name: DATUM
Data Element: DATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATUM

INDEX_STAT-UZEIT table field - Time ▼

Description: Time
Field Name: UZEIT
Data Element: UZEIT
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UZEIT

INDEX_STAT-HEIGHT table field - height of the b-tree ▼

Description: height of the b-tree
Field Name: HEIGHT
Data Element: HEIGHT
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HEIGHT

INDEX_STAT-BLOCKS table field - Number of blocks ▼

Description: Number of blocks
Field Name: BLOCKS
Data Element: NUMBER_BLK
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKS

INDEX_STAT-LF_ROWS table field - number of leaf rows (values in the index) ▼

Description: number of leaf rows (values in the index)
Field Name: LF_ROWS
Data Element: LF_ROWS
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LF_ROWS

INDEX_STAT-LF_BLKS table field - number of leaf blocks in the b-tree ▼

Description: number of leaf blocks in the b-tree
Field Name: LF_BLKS
Data Element: LF_BLKS
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LF_BLKS

INDEX_STAT-LF_ROW_LEN table field - sum of the lengths of all the branch blocks ▼

Description: sum of the lengths of all the branch blocks
Field Name: LF_ROW_LEN
Data Element: LF_ROW_LEN
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LF_ROW_LEN

INDEX_STAT-LF_BLK_LEN table field - number of leaf blocks in the b-tree ▼

Description: number of leaf blocks in the b-tree
Field Name: LF_BLK_LEN
Data Element: LF_BLK_LEN
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LF_BLK_LEN

INDEX_STAT-BR_ROWS table field - number of branch rows ▼

Description: number of branch rows
Field Name: BR_ROWS
Data Element: BR_ROWS
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BR_ROWS

INDEX_STAT-BR_BLKS table field - number of branch blocks in the b-tree ▼

Description: number of branch blocks in the b-tree
Field Name: BR_BLKS
Data Element: BR_BLKS
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BR_BLKS

INDEX_STAT-BR_ROW_LEN table field - sum of the lengths of all the branch blocks ▼

Description: sum of the lengths of all the branch blocks
Field Name: BR_ROW_LEN
Data Element: BR_ROW_LEN
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BR_ROW_LEN

INDEX_STAT-BR_BLK_LEN table field - usable space in a branch block ▼

Description: usable space in a branch block
Field Name: BR_BLK_LEN
Data Element: BR_BLK_LEN
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BR_BLK_LEN

INDEX_STAT-DEL_LF_ROW table field - number of deleted leaf rows in the index ▼

Description: number of deleted leaf rows in the index
Field Name: DEL_LF_ROW
Data Element: DEL_LF_ROW
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEL_LF_ROW

INDEX_STAT-DEL_LF_LEN table field - total length of all deleted rows in the index ▼

Description: total length of all deleted rows in the index
Field Name: DEL_LF_LEN
Data Element: DEL_LF_LEN
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEL_LF_LEN

INDEX_STAT-DIST_KEYS table field - Number of distinct keys in index ▼

Description: Number of distinct keys in index
Field Name: DIST_KEYS
Data Element: DIST_KEYS
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIST_KEYS

INDEX_STAT-REP_KEYS table field - how many times the most repeated key is repeated ▼

Description: how many times the most repeated key is repeated
Field Name: REP_KEYS
Data Element: REP_KEYS
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REP_KEYS

INDEX_STAT-BTREE_SPAC table field - total space currently allocated in the b-tree ▼

Description: total space currently allocated in the b-tree
Field Name: BTREE_SPAC
Data Element: BTREE_SPAC
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BTREE_SPAC

INDEX_STAT-USED_SPACE table field - total space that is currently being used ▼

Description: total space that is currently being used
Field Name: USED_SPACE
Data Element: USED_SPACE
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USED_SPACE

INDEX_STAT-PCT_USED table field - PCT_USED ▼

Description: PCT_USED
Field Name: PCT_USED
Data Element: PCT_USED_
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_USED

INDEX_STAT-ROWS_PER_K table field - average number of rows per distinct key ▼

Description: average number of rows per distinct key
Field Name: ROWS_PER_K
Data Element: ROWS_PER_K
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWS_PER_K

INDEX_STAT-BLKS_GETS table field - Expected number of consistent mode block gets per row ▼

Description: Expected number of consistent mode block gets per row
Field Name: BLKS_GETS
Data Element: BLKS_GETS
Data Type: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLKS_GETS

View list of all SAP tables(S4H/ECC)

Select data from SAP table