MariaDB 5.3 optimizer_switch
@@optimizer_switch is a server variable that one can use to enable/disable specific optimizations. For generic syntax, see TODO.
Here's a list of @@optimizer switch flags in MariaDB 5.3:
index_merge=on index_merge_union=on index_merge_sort_union=on index_merge_intersection=on index_merge_sort_intersection=off
derived_merge=on derived_with_keys=on
index_condition_pushdown=on
materialization=on subquery_cache=on
semijoin=on firstmatch=off loosescan=off in_to_exists=on
partial_match_rowid_merge=on partial_match_table_scan=on
mrr=on mrr_cost_based=off mrr_sort_keys=on
join_cache_bka=on join_cache_hashed=on join_cache_incremental=on outer_join_with_cache=off semijoin_with_cache=off optimize_join_buffer_size=on
table_elimination=on