执行路径的提示:
ALL_ROWS
FIRST_ROWS(n)
访问方法提示:
FULL
INDEX、INDEX_ASC、INDEX_DESC
NO_INDEX、NO_INDEX_FFS、NO_INDEX_SS
INDEX_COMBINE
INDEX_JOIN
INDEX_FFS
INDEX_SS、INDEX_SS_ASC、INDEX_SS_DESC
查询转换提示:
FACT、NO_FACT
MERGE,NO_MERGE
USE_CONCAT,NO_EXPAND
REWRITE,NO_REWRITE
STAR_TRANSFORMATION,NO_STAR_TRANSFORMATION
UNNEST,NO_UNNEST
连接操作提示:
LEADING,ORDERED
USE_HASH,NO_USE_HASH
USE_MERGE,NO_USE_MERGE
USE_NL,USE_NL_WITH_INDEX,NO_USE_NL
PARALLEL,NO_PARALLEL
其他提示:
APPEND,NOAPPEND
CACHE,NOCACHE
CURSOR_SHARING_EXACT
DRIVING_SITE
dynamic_sampling
MODEL_MIN_ANALYSIS
PUSH_PRED,NO_PUSH_PRED
PUSH_SUBQ,NO_PUSH_SUBQ
QB_NAME
OPT_PARAM
RESULT_CACHE,NO_RESULT_CACHE
老实说,感觉O记的花活儿还是很多很多很多的,佩服佩服~~~~~