Undocumented Hints ( You won't find this mentioned under Oracle Official documentation).. They are TOP Secret!
- 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_expand_gset_to_union
- no_fact
- 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
- sqlldr
- sys_dl_cursor
- sys_parallel_txn
- sys_rid_order
- tiv_gb
- tiv_ssf
- unnest
- use_ttt_for_gsets
Documented Hints
- all_rows
- first_rows
- first_rows_1
- first_rows_100
- choose
- rule
- full
- rowid
- cluster
- hash
- hash_aj
- 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
- no_query_transformation
- use_concat
- no_expand
- rewrite
- norewrite
- no_rewrite
- merge
- no_merge
- fact
- no_fact
- star_transformation
- no_star_transformation
- unnest
- no_unnest
- leading
- ordered
- use_nl
- no_use_nl
- use_nl_with_index
- use_merge
- no_use_merge
- use_hash
- no_use_hash
- parallel
- noparallel / no_parallel
- pq_distribute
- no_parallel_index
- 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
- merge_aj
- and_equal
- star
- bitmap
- hash_sj
- nl_sj
- nl_aj
- ordered_predicates
- expand_gset_to_union
