Hints for Optimization Approaches and Goals
Hints for Access Paths
- FULL
- CLUSTER
- HASH
- INDEX
- NO_INDEX
- INDEX_ASC
- INDEX_COMBINE
- INDEX_JOIN
- INDEX_DESC
- INDEX_FFS
- NO_INDEX_FFS
- INDEX_SS
- INDEX_SS_ASC
- INDEX_SS_DESC
- NO_INDEX_SS
Hints for Query Transformations
- NO_QUERY_TRANSFORMATION
- USE_CONCAT
- NO_EXPAND
- REWRITE
- NO_REWRITE
- MERGE
- NO_MERGE
- STAR_TRANSFORMATION
- NO_STAR_TRANSFORMATION
- FACT
- NO_FACT
- UNNEST
- NO_UNNEST
Hints for Join Orders
Hints for Join Operations
Hints for Parallel Execution
Additional Hints
- APPEND
- NOAPPEND
- CACHE
- NOCACHE
- PUSH_PRED
- NO_PUSH_PRED
- PUSH_SUBQ
- NO_PUSH_SUBQ
- QB_NAME
- CURSOR_SHARING_EXACT
- DRIVING_SITE
- DYNAMIC_SAMPLING
- SPREAD_MIN_ANALYSIS
沒有留言:
張貼留言