blob: 4193bf0739e3e4eebf37e3377e9496cb25d37456 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
call sys.optimizer_switch_on();
option opt
condition_pushdown_for_derived on
condition_pushdown_for_subquery on
condition_pushdown_from_having on
derived_merge on
derived_with_keys 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
semijoin on
semijoin_with_cache on
split_materialized on
subquery_cache on
table_elimination on
call sys.optimizer_switch_off();
option opt
engine_condition_pushdown off
index_merge_sort_intersection off
mrr off
mrr_cost_based off
mrr_sort_keys off
not_null_range_scan off
|