call sys.optimizer_switch_on();
option opt
condition_pushdown_for_derived on
condition_pushdown_for_subquery on
condition_pushdown_from_having on
cset_narrowing on
derived_merge on
derived_with_keys on
duplicateweedout on
exists_to_in on
extended_keys on
firstmatch on
hash_join_cardinality on
index_condition_pushdown on
index_merge on
index_merge_intersection on
index_merge_sort_union on
index_merge_union on
in_to_exists on
join_cache_bka on
join_cache_hashed on
join_cache_incremental on
loosescan on
materialization on
optimize_join_buffer_size on
orderby_uses_equalities on
outer_join_with_cache on
partial_match_rowid_merge on
partial_match_table_scan on
rowid_filter on
sargable_casefold on
semijoin on
semijoin_with_cache on
split_materialized on
subquery_cache on
table_elimination on
call sys.optimizer_switch_off();
option opt
index_merge_sort_intersection off
mrr off
mrr_cost_based off
mrr_sort_keys off
not_null_range_scan off
reorder_outer_joins off