| 1 |
call sys.optimizer_switch_on(); |
| 2 |
option opt |
| 3 |
condition_pushdown_for_derived on |
| 4 |
condition_pushdown_for_subquery on |
| 5 |
condition_pushdown_from_having on |
| 6 |
cset_narrowing on |
| 7 |
derived_merge on |
| 8 |
derived_with_keys on |
| 9 |
exists_to_in on |
| 10 |
extended_keys on |
| 11 |
firstmatch on |
| 12 |
hash_join_cardinality on |
| 13 |
index_condition_pushdown on |
| 14 |
index_merge on |
| 15 |
index_merge_intersection on |
| 16 |
index_merge_sort_union on |
| 17 |
index_merge_union on |
| 18 |
in_to_exists on |
| 19 |
join_cache_bka on |
| 20 |
join_cache_hashed on |
| 21 |
join_cache_incremental on |
| 22 |
loosescan on |
| 23 |
materialization on |
| 24 |
optimize_join_buffer_size on |
| 25 |
orderby_uses_equalities on |
| 26 |
outer_join_with_cache on |
| 27 |
partial_match_rowid_merge on |
| 28 |
partial_match_table_scan on |
| 29 |
rowid_filter on |
| 30 |
sargable_casefold on |
| 31 |
semijoin on |
| 32 |
semijoin_with_cache on |
| 33 |
split_materialized on |
| 34 |
subquery_cache on |
| 35 |
table_elimination on |
| 36 |
call sys.optimizer_switch_off(); |
| 37 |
option opt |
| 38 |
index_merge_sort_intersection off |
| 39 |
mrr off |
| 40 |
mrr_cost_based off |
| 41 |
mrr_sort_keys off |
| 42 |
not_null_range_scan off |