Debian Codegraph @

mysql-test/suite/sysschema/r/optimizer_switch.result

raw
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