Details |
/SDF/ORAIDXINF2-ANALY_ID table field - Analysis ID
▼
Description: Analysis ID Field Name: ANALY_ID 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 ANALY_ID
|
/SDF/ORAIDXINF2-STMT_ID table field - Statement ID
▼
Description: Statement ID Field Name: STMT_ID 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 STMT_ID
|
/SDF/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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/ORAIDXINF2-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
|
/SDF/ORAIDXINF2-STMT_SOURCE table field - DBA HIST (D) or cache (C)
▼
Description: DBA HIST (D) or cache (C) Field Name: STMT_SOURCE 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 STMT_SOURCE
|
/SDF/ORAIDXINF2-DBA_HIST_B_TS table field - Start of time stamp for statement selection from DBA HIST
▼
Description: Start of time stamp for statement selection from DBA HIST Field Name: DBA_HIST_B_TS 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 DBA_HIST_B_TS
|
/SDF/ORAIDXINF2-DBA_HIST_E_TS table field - End of time stamp for statement selection from DBA HIST
▼
Description: End of time stamp for statement selection from DBA HIST Field Name: DBA_HIST_E_TS 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 DBA_HIST_E_TS
|