첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.
728x90
반응형
728x170
구분 힌트
Optimization Goals and Approaches ALL_ROWS 혹은 FIRST_ROWS
CHOOSE
RULE
Acess Method Hints AND_EQUAL
CLUSTER
FULL
HASH
INDEX 혹은 NO_INDEX
INDEX_ASC 혹은 INDEX_DESC
INDEX_COMBINE
INDEX_FFS
ROWID
Join Order Hints ORDERED
STAR
Join Operation Hints DRIVING_SITE
HASH_SJ, MERGE_SJ 혹은 NL_SJ
LEADING
USE_HASH 혹은 USE_MERGE
USE_NL
Parallel Execution Hints PARALLEL 혹은 NOPARALLEL
PARALLEL_INDEX
PQ_DISTRIBUTE
NOPARALLEL_INDEX
Query Transformation Hints EXPAND_GSET_TO_UNION
FACT 혹은 NOFACT
MERGE
NO_EXPAND
NO_MERGE
REWIRTE 혹은 NOREWRITE
STAR_TRANSFORMATION
USE_CONCAT
Other Hints APPEND 혹은 NOAPPEND
CACHE 혹은 NOCACHE
CURSOR_SHARED_EXACT
DYNAMIC_SAMPLING
NESTED_TABLE_GET_REFS
UNNEST 혹은 NO_UNNEST
ORDERED_PREDICATES

 

728x90
반응형
그리드형(광고전용)
Posted by icodebroker

댓글을 달아 주세요