SQL_FEATURE DESCRIPTION
------------------------------------------------------- --------------------------------------------------
ALL A Universal Feature
ANSI_REARCH ANSI rearcihtecture
COMPILATION SQL COMPILATION
CBO SQL Cost Based Optimization
ACCESS_PATH Query access path
AND_EQUAL Index and-equal access path
BITMAP_TREE Bitmap tree access path
FULL Full table scan
INDEX Index
INDEX_ASC Index (ascending)
INDEX_COMBINE Combine index for bitmap access
INDEX_DESC Use index (descending)
INDEX_FFS Index fast full scan
INDEX_JOIN Index join
INDEX_RS_ASC Index range scan
INDEX_RS_DESC Index range scan descending
INDEX_SS Index skip scan
INDEX_SS_ASC Index skip scan ascending
INDEX_SS_DESC Index skip scan descending
SORT_ELIM Sort Elimination Via Index
ADAPTIVE_PLAN Adaptive plans
AUTO_REOPT Automatic reoptimization
PERF_FEEDBACK Performance feedback
STATS_FEEDBACK Statistics feedback
BUSHY_JOIN bushy join
CBQT Cost Based Query Transformation
CBQT_OR_EXPANSION Cost Based OR Expansion
CVM Complex View Merging
DIST_PLCMT Distinct Placement
JOINFAC Join Factorization
JPPD Join Predicate Push Down
PLACE_GROUP_BY Group-By Placement
PULL_PRED pull predicates
STAR_TRANS Star Transformation
TABLE_LOOKUP_BY_NL Table Lookup By Nested Loop
TABLE_EXPANSION Table Expansion
UNNEST unnest query block
VECTOR_AGG Vector Transformation
CURSOR_SHARING Cursor sharing
DML DML
JOIN_METHOD Join methods
USE_CUBE Cube join
USE_HASH Hash join
USE_MERGE Sort-merge join
USE_MERGE_CARTESIAN Merge join cartesian
USE_NL Nested-loop join
USE_NL_WITH_INDEX Nested-loop index join
JOIN_ORDER Join order
OPT_MODE Optimizer mode
ALL_ROWS All rows (optimizer mode)
CHOOSE Choose (optimizer mode)
FIRST_ROWS First rows (optimizer mode)
OR_EXPAND OR expansion
OUTLINE Outlines
PARTIAL_JOIN Partial Join Evaluation
PARTITION Partition
PQ Parallel Query
PARALLEL Parallel table
PQ_DISTRIBUTE PQ Distribution method
PQ_MAP PQ slave mapper
PQ_REPLICATE PQ replicate small tables
PX_JOIN_FILTER Bloom filtering for joins
STAR_TRANS Star Transformation
TABLE_LOOKUP_BY_NL Table Lookup By Nested Loop
STATS Optimizer statistics
CARDINALITY Cardinality computation
COLUMN_STATS Basic column statistics
CPU_COSTING CPU costing
DBMS_STATS Statistics gathered by DBMS_STATS
DYNAMIC_SAMPLING Dynamic sampling
DYNAMIC_SAMPLING_EST_CDN Estimate CDN using dynamic sampling
GATHER_PLAN_STATISTICS Gather plan statistics
INDEX_STATS Basic index statistics
OPT_ESTIMATE Optimizer estimates
TABLE_STATS Basic table statistics
DATA_SECURITY_REWRITE XS Data Security Rewrite
QUERY_REWRITE query rewrite with materialized views
RBO SQL Rule Based Optimization
SQL_CODE_GENERATOR SQL Code Generator
SQL_MANAGEMENT_BASE SQL Management base
SQL_PLAN_MANAGEMENT SQL Plan Management
TRANSFORMATION Query Transformation
CBQT Cost Based Query Transformation
CBQT_OR_EXPANSION Cost Based OR Expansion
CVM Complex View Merging
DIST_PLCMT Distinct Placement
JOINFAC Join Factorization
JPPD Join Predicate Push Down
PLACE_GROUP_BY Group-By Placement
PULL_PRED pull predicates
STAR_TRANS Star Transformation
TABLE_LOOKUP_BY_NL Table Lookup By Nested Loop
TABLE_EXPANSION Table Expansion
UNNEST unnest query block
VECTOR_AGG Vector Transformation
CLUSTER_BY_ROWID Cluster By Rowid Transformation
GROUPING_SET_XFORM Grouping Set Transformation
HEURISTIC Heuristic Query Transformation
CNT Count(col) to count(*)
COALESCE_SQ coalesce subqueries
CSE Common Sub-Expression Elimination
CVM Complex View Merging
DECORRELATE View Decorrelation
ELIMINATE_SQ eliminate subqueries
FILTER_PUSH_PRED Push filter predicates
FULL_OUTER_JOIN_TO_OUTER Join Conversion
GBYEL Group-by Elimination
JPPD Join Predicate Push Down
OBYE Order-by Elimination
OLD_PUSH_PRED Old push predicate algorithm (pre-10.1.0.3)
OUTER_JOIN_TO_ANTI Join Conversion
OUTER_JOIN_TO_INNER Join Conversion
PRED_MOVE_AROUND Predicate move around
SET_TO_JOIN Transform set operations to joins
SVM Simple View Merging
TABLE_ELIM Table Elimination
UNNEST unnest query block
USE_CONCAT Or-optimization
XML_REWRITE XML Rewrite
CHECK_ACL_REWRITE Check ACL Rewrite
COST_XML_QUERY_REWRITE Cost Based XML Query Rewrite
XMLINDEX_REWRITE XMLIndex Rewrite
ZONEMAP Zone Maps
DDL DDL
EXECUTION SQL EXECUTION
STATS_ONLOAD Statistics on load
VECTOR_PROC Vector Processing
WINDOW_CONSOLIDATOR WINDOW CONSOLIDATOR