Search notes:
Oracle: Hints and their irregular inverse counterparts
The following query finds
hints where the negative (inverse) variant is not simply
no or
no_ prepended to the hint name:
select
lower(name ) nam,
lower(inverse) inv
from
v$sql_hint
where
regexp_replace(name, '^NO_?', '') != regexp_replace(inverse, '^NO_?', '')
order by
name;
--
-- NAM INV
-- -------------------------------- ----------------------------------------------------------------
-- append_values noappend
-- cache_cb nocache
-- data_security_rewrite_limit no_data_security_rewrite
-- disable_parallel_dml enable_parallel_dml
-- domain_index_no_sort domain_index_sort
-- domain_index_sort domain_index_no_sort
-- enable_parallel_dml disable_parallel_dml
-- force_json_table_transform no_json_table_transform
-- force_xml_query_rewrite no_xml_query_rewrite
-- index_asc no_index
-- index_desc no_index
-- index_ss_asc no_index_ss
-- index_ss_desc no_index_ss
-- inline materialize
-- materialize inline
-- noparallel shared
-- no_basetable_multimv_rewrite rewrite
-- no_data_security_rewrite data_security_rewrite_limit
-- no_expand use_concat
-- no_json_table_transform force_json_table_transform
-- no_multimv_rewrite rewrite
-- no_parallel shared
-- no_ref_cascade ref_cascade_cursor
-- no_xml_query_rewrite force_xml_query_rewrite
-- pq_map pq_nomap
-- pq_nomap pq_map
-- ref_cascade_cursor no_ref_cascade
-- shared no_parallel
-- use_concat no_expand
-- use_nl_with_index no_use_nl