| Details |
/SDF/ORAIDXINFO-INDEX_OWNER table field - Index owner
▼
Description: Index owner
Field Name: INDEX_OWNER
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 INDEX_OWNER
|
/SDF/ORAIDXINFO-INDEX_NAME table field - Index Name
▼
Description: Index Name
Field Name: INDEX_NAME
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 INDEX_NAME
|
/SDF/ORAIDXINFO-INDEX_TYPE table field - Index Type
▼
Description: Index Type
Field Name: INDEX_TYPE
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 INDEX_TYPE
|
/SDF/ORAIDXINFO-TABLE_NAME table field - Table Name
▼
Description: Table Name
Field Name: TABLE_NAME
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 TABLE_NAME
|
/SDF/ORAIDXINFO-UNIQUENESS table field - Uniqueness
▼
Description: Uniqueness
Field Name: UNIQUENESS
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 UNIQUENESS
|
/SDF/ORAIDXINFO-BLEVEL table field - B Tree Level
▼
Description: B Tree Level
Field Name: BLEVEL
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 BLEVEL
|
/SDF/ORAIDXINFO-LEAF_BLKS table field - Number of Leaf Blocks in Index
▼
Description: Number of Leaf Blocks in Index
Field Name: LEAF_BLKS
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 LEAF_BLKS
|
/SDF/ORAIDXINFO-STATUS table field - Status
▼
Description: Status
Field Name: STATUS
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 STATUS
|
/SDF/ORAIDXINFO-NUM_ROWS table field - Number of rows in index
▼
Description: Number of rows in index
Field Name: NUM_ROWS
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 NUM_ROWS
|
/SDF/ORAIDXINFO-DIST_KEYS table field - Number of Distinct Keys in Ind
▼
Description: Number of Distinct Keys in Ind
Field Name: DIST_KEYS
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 DIST_KEYS
|
/SDF/ORAIDXINFO-AVG_LEAF_B table field - Average Number of Leaf Blocks
▼
Description: Average Number of Leaf Blocks
Field Name: AVG_LEAF_B
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 AVG_LEAF_B
|
/SDF/ORAIDXINFO-AVG_DATA_B table field - Average Number of Data Blocks
▼
Description: Average Number of Data Blocks
Field Name: AVG_DATA_B
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 AVG_DATA_B
|
/SDF/ORAIDXINFO-CLUST_FACT table field - Clustering Factor
▼
Description: Clustering Factor
Field Name: CLUST_FACT
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 CLUST_FACT
|
/SDF/ORAIDXINFO-SAMPL_SIZE table field - Sample Size
▼
Description: Sample Size
Field Name: SAMPL_SIZE
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 SAMPL_SIZE
|
/SDF/ORAIDXINFO-LAST_ANALY table field - Date of Last Analysis of
▼
Description: Date of Last Analysis of
Field Name: LAST_ANALY
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 LAST_ANALY
|
/SDF/ORAIDXINFO-COL_COUNT table field - Number of Columns in Index
▼
Description: Number of Columns in Index
Field Name: COL_COUNT
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 COL_COUNT
|
/SDF/ORAIDXINFO-FREELISTS table field - Number of freelists
▼
Description: Number of freelists
Field Name: FREELISTS
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 FREELISTS
|
/SDF/ORAIDXINFO-FREELIST_GROUPS table field - Number of freelists groups
▼
Description: Number of freelists groups
Field Name: FREELIST_GROUPS
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 FREELIST_GROUPS
|
/SDF/ORAIDXINFO-DEGREE table field - Number of threads per instance
▼
Description: Number of threads per instance
Field Name: DEGREE
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 DEGREE
|
/SDF/ORAIDXINFO-PARTITIONED table field - Partitioned YES or noNumber of
▼
Description: Partitioned YES or noNumber of
Field Name: PARTITIONED
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 PARTITIONED
|
/SDF/ORAIDXINFO-TEMPORARY table field - Whether the index is on a temporary table
▼
Description: Whether the index is on a temporary table
Field Name: TEMPORARY
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 TEMPORARY
|
/SDF/ORAIDXINFO-GENERATED table field - Whether the name of the index is system generated
▼
Description: Whether the name of the index is system generated
Field Name: GENERATED
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 GENERATED
|
/SDF/ORAIDXINFO-SECONDARY table field - Whether the index is a secondary object created by the ODC
▼
Description: Whether the index is a secondary object created by the ODC
Field Name: SECONDARY
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 SECONDARY
|
/SDF/ORAIDXINFO-BUFFER_POOL table field - Name of default buffer poolPar
▼
Description: Name of default buffer poolPar
Field Name: BUFFER_POOL
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 BUFFER_POOL
|
/SDF/ORAIDXINFO-GLOBAL_STATS table field - For partitioned indexes, statistics with analyze or not
▼
Description: For partitioned indexes, statistics with analyze or not
Field Name: GLOBAL_STATS
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 GLOBAL_STATS
|
/SDF/ORAIDXINFO-USER_STATS table field - Statistics entered by userName of default buffer pool
▼
Description: Statistics entered by userName of default buffer pool
Field Name: USER_STATS
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 USER_STATS
|
/SDF/ORAIDXINFO-KB_USED table field - KB used to store index info
▼
Description: KB used to store index info
Field Name: KB_USED
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 KB_USED
|
/SDF/ORAIDXINFO-KB_NEEDED table field - KB needed to store index info
▼
Description: KB needed to store index info
Field Name: KB_NEEDED
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 KB_NEEDED
|
/SDF/ORAIDXINFO-IDX_SQ table field - Idx Storage Quality CBO based
▼
Description: Idx Storage Quality CBO based
Field Name: IDX_SQ
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 IDX_SQ
|
/SDF/ORAIDXINFO-MONITORING table field - Yes / no
▼
Description: Yes / no
Field Name: MONITORING
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 MONITORING
|
/SDF/ORAIDXINFO-USED table field - Yes / no
▼
Description: Yes / no
Field Name: USED
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 USED
|
/SDF/ORAIDXINFO-START_MONITORING table field - start monitoring in sys.object
▼
Description: start monitoring in sys.object
Field Name: START_MONITORING
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 START_MONITORING
|
/SDF/ORAIDXINFO-END_MONITORING table field - end monitoring time in sys.obj
▼
Description: end monitoring time in sys.obj
Field Name: END_MONITORING
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 END_MONITORING
|
/SDF/ORAIDXINFO-COMPRESSION table field - Index compression is enabled ENABLED or DISABLED
▼
Description: Index compression is enabled ENABLED or DISABLED
Field Name: COMPRESSION
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 COMPRESSION
|
/SDF/ORAIDXINFO-PREFIX_LENGTH table field - Number of columns in the prefix of the compression key
▼
Description: Number of columns in the prefix of the compression key
Field Name: PREFIX_LENGTH
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 PREFIX_LENGTH
|
/SDF/ORAIDXINFO-TABLESPACE_NAME table field - Name of the tablespace containing the index
▼
Description: Name of the tablespace containing the index
Field Name: TABLESPACE_NAME
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 TABLESPACE_NAME
|
/SDF/ORAIDXINFO-INI_TRANS table field - Initial Number of Transactions
▼
Description: Initial Number of Transactions
Field Name: INI_TRANS
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 INI_TRANS
|
/SDF/ORAIDXINFO-MAX_TRANS table field - Maximum no. of transactions
▼
Description: Maximum no. of transactions
Field Name: MAX_TRANS
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 MAX_TRANS
|
/SDF/ORAIDXINFO-INITIAL_EXTENT table field - Size of the initial extent
▼
Description: Size of the initial extent
Field Name: INITIAL_EXTENT
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 INITIAL_EXTENT
|
/SDF/ORAIDXINFO-NEXT_EXTENT table field - Size of secondary extents
▼
Description: Size of secondary extents
Field Name: NEXT_EXTENT
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 NEXT_EXTENT
|
/SDF/ORAIDXINFO-MIN_EXTENTS table field - Minimum number of extents allowed in the segment
▼
Description: Minimum number of extents allowed in the segment
Field Name: MIN_EXTENTS
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 MIN_EXTENTS
|
/SDF/ORAIDXINFO-MAX_EXTENTS table field - Maximum number of extents allowed in the segment
▼
Description: Maximum number of extents allowed in the segment
Field Name: MAX_EXTENTS
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 MAX_EXTENTS
|
/SDF/ORAIDXINFO-PCT_INCREASE table field - Percentage increase in extent size
▼
Description: Percentage increase in extent size
Field Name: PCT_INCREASE
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 PCT_INCREASE
|
/SDF/ORAIDXINFO-PCT_THRESHOLD table field - Threshold percentage of block space allowed per index entry
▼
Description: Threshold percentage of block space allowed per index entry
Field Name: PCT_THRESHOLD
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 PCT_THRESHOLD
|
/SDF/ORAIDXINFO-PCT_FREE table field - Minimum Percentage of Free Space in a Block
▼
Description: Minimum Percentage of Free Space in a Block
Field Name: PCT_FREE
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 PCT_FREE
|
/SDF/ORAIDXINFO-CREATED table field - Timestamp for Creation of Object
▼
Description: Timestamp for Creation of Object
Field Name: CREATED
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 CREATED
|
/SDF/ORAIDXINFO-LAST_DDL_TIME table field - Timestamp for Last Modification from a DDL Command
▼
Description: Timestamp for Last Modification from a DDL Command
Field Name: LAST_DDL_TIME
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 LAST_DDL_TIME
|
/SDF/ORAIDXINFO-LOGGING table field - Changes to the index are logged (Y or N)
▼
Description: Changes to the index are logged (Y or N)
Field Name: LOGGING
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 LOGGING
|
/SDF/ORAIDXINFO-JOIN_INDEX table field - Indicates whether the index is a join index
▼
Description: Indicates whether the index is a join index
Field Name: JOIN_INDEX
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 JOIN_INDEX
|
/SDF/ORAIDXINFO-IOT_RED_PK_ELIM table field - Redundant primary key columns are eliminated (Y or N)
▼
Description: Redundant primary key columns are eliminated (Y or N)
Field Name: IOT_RED_PK_ELIM
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 IOT_RED_PK_ELIM
|
/SDF/ORAIDXINFO-DROPPED table field - Indicates if index has been dropped and is in recycle bin
▼
Description: Indicates if index has been dropped and is in recycle bin
Field Name: DROPPED
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 DROPPED
|
/SDF/ORAIDXINFO-VISIBILITY table field - Indicates if index is VISIBLE or INVISIBLE to the optimizer
▼
Description: Indicates if index is VISIBLE or INVISIBLE to the optimizer
Field Name: VISIBILITY
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 VISIBILITY
|
/SDF/ORAIDXINFO-FUNCIDX_STATUS table field - Status of a function-based index
▼
Description: Status of a function-based index
Field Name: FUNCIDX_STATUS
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 FUNCIDX_STATUS
|
/SDF/ORAIDXINFO-FLASH_CACHE table field - Database Smart Flash Cache hint for index
▼
Description: Database Smart Flash Cache hint for index
Field Name: FLASH_CACHE
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 FLASH_CACHE
|
/SDF/ORAIDXINFO-CELL_F_CACHE table field - Cell flash cache hint for index blocks
▼
Description: Cell flash cache hint for index blocks
Field Name: CELL_F_CACHE
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 CELL_F_CACHE
|
/SDF/ORAIDXINFO-PCT_DIR_ACC table field - For a secondary index on an index-organized table, the perce
▼
Description: For a secondary index on an index-organized table, the perce
Field Name: PCT_DIR_ACC
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 PCT_DIR_ACC
|
/SDF/ORAIDXINFO-ORPHANED_ENTRIES table field - Ind if a glob ind cont stale ent due to def ind maint
▼
Description: Ind if a glob ind cont stale ent due to def ind maint
Field Name: ORPHANED_ENTRIES
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 ORPHANED_ENTRIES
|
/SDF/ORAIDXINFO-INDEXING table field - Indicates whether a global index is decoupled from table
▼
Description: Indicates whether a global index is decoupled from table
Field Name: INDEXING
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 INDEXING
|
