힌트의 종류별 분류

힌트의 종류 별 분류

 

1.     Optimization Goals and Approaches

-       ALL_ROWS 혹은 FIRST_ROWS

-       CHOOSE

-       RULE

 

2.     Access Method Hints

-       AND_EQUAL

-       CLUSTER

-       FULL

-       HASH

-       INDEX 혹은 NO_INDEX

-       INDEX_ASC 혹은 INDEX_DESC

-       INDEX_COMBINE

-       INDEX_FFS

-       ROWID

 

3.     Join Order Hints

-       ORDERED

-       STAR

 

4.     Join Operation Hints

-       DRIVING_SITE

-       HASH_SJ, MERGE_SJ 혹은 NL_SJ

-       LEADING

-       USE_HASH 혹은 USE_MERGE

-       USE_NL

 

5.     Parallel Execution Hints

-       PARALLEL 혹은 NOPARALLEL

-       PARALLEL_INDEX

-       PQ_DISTRIBUTE

-       NOPARALLEL_INDEX

 

6.     Query Transformation Hints

-       EXPAND_GSET_TO_UNION

-       FACT 혹은 NOFACT

-       MERGE

-       NO_EXPAND

-       NO_MERGE

-       REWRITE 혹은 NOREWRITE

-       STAR_TRANSFORMATION

-       USE_CONCAT

 

7.     Other Hints

-       APPEND 혹은 NOAPPEND

-       CACHE 혹은 NOCACHE

-       CURSOR_SHARING_EXACT

-       DYNAMIC_SAMPLING

-       UNNEST 혹은 NO_UNNEST

-       ORDERED_PREDICATES