Databases Reference
In-Depth Information
SELECT
/*+ INDEX (employees employee_dept_inx)*/
employee_id, department_id
FROM employees
WHERE department_id < 35;
The following list shows the range of supported Oracle hints and the undocu-
mented hints as well.
ALL_ROWS, AND_EQUAL, ANTIJOIN, APPEND, BITMAP, BUFFER,
CACHE, CARDINALITY, CHOOSE, CLUSTER FULL, CPU_COSTING,
DRIVING_SITE, FACT, FIRST_ROWS, HASH, ROWID, HASH_AJ,
HASH_SJ, INDEX, INDEX_ASC, INDEX_COMBINE, INDEX_DESC,
INDEX_FFS, INDEX_JOIN, INLINE, LEADING,
MATERIALIZE, MERGE, MERGE_AJ, MERGE_SJ, NL_AJ, NL_SJ,
NO_ACCESS, NO_BUFFER, NO_EXPAND,
NO_EXPAND_GSET_TO_UNION, NO_FACT, NO_INDEX, NO_MERGE,
NO_MONITORING, NO_PUSH_PRED, NO_PUSH_SUBQ, NO_QKN_BUFF,
NO_SEMIJOIN, NOAPPEND, NOCACHE, NOPARALLEL,
NOPARALLEL_INDEX, NOREWRITE, OR_EXPAND, ORDERED,
ORDERED_PREDICATES, PARALLEL, PARALLEL_INDEX,
PQ_DISTRIBUTE, PUSH_PRED, PUSH_SUBQ, REWRITE ,RULE,
SELECTIVITY, SEMIJOIN, SEMIJOIN_DRIVER, STAR,
STAR_TRANSFORMATION, SWAP_JOIN_INPUTS, USE_ANTI,
USE_CONCAT, USE_HASH, USE_MERGE, USE_NL, USE_SEMI.
Undocumented hints:
BYPASS_RECURSIVE_CHECK, BYPASS_UJVC, CACHE_CB,
CACHE_TEMP_TABLE, CIV_GB, COLLECTIONS_GET_REFS, CUBE_GB,
CURSOR_SHARING_EXACT, DEREF_NO_REWRITE, DML_UPDATE,
DOMAIN_INDEX_NO_SORT, DOMAIN_INDEX_SORT,
DYNAMIC_SAMPLING, DYNAMIC_SAMPLING_EST_CDN,
EXPAND_GSET_TO_UNION, FORCE_SAMPLE_BLOCK,
GBY_CONC_ROLLUP, GLOBAL_TABLE_HINTS,
HWM_BROKERED, IGNORE_ON_CLAUSE, IGNORE_WHERE_CLAUSE,
INDEX_RRS, INDEX_SS, INDEX_SS_ASC, INDEX_SS_DESC,
LIKE_EXPAND, LOCAL_INDEXES, MV_MERGE,
NESTED_TABLE_GET_REFS, NESTED_TABLE_SET_REFS,
NESTED_TABLE_SET_SETID, NO_FILTERING, NO_ORDER_ROLLUPS,
NO_PRUNE_GSETS, NO_STATS_GSETS, NO_UNNEST,
NOCPU_COSTING, OVERFLOW_NOMOVE, PIV_GB, PIV_SSF, PQ_MAP,
PQ_NOMAP, REMOTE_MAPPED, RESTORE_AS_INTERVALS,
SAVE_AS_INTERVALS, SCN_ASCENDING, SKIP_EXT_OPTIMIZER,
