diff options
| author | unknown <timour@askmonty.org> | 2011-11-21 17:48:25 +0200 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-11-21 17:48:25 +0200 |
| commit | e9a6502f261d927719762dab11aac8b2af50ff34 (patch) | |
| tree | 7cd903159f2c7042631825d3dec6ea808698d3be /sql/mysql_priv.h | |
| parent | 0693f4d9168eeee399f9d636c9ba81981e484daf (diff) | |
| parent | f0d9908fc3582cf08db7e0376f0e243b1e754ad5 (diff) | |
| download | mariadb-git-e9a6502f261d927719762dab11aac8b2af50ff34.tar.gz | |
Merge enabling materialization=on by default.
Diffstat (limited to 'sql/mysql_priv.h')
| -rw-r--r-- | sql/mysql_priv.h | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/sql/mysql_priv.h b/sql/mysql_priv.h index a2577e4b71c..298f31d8494 100644 --- a/sql/mysql_priv.h +++ b/sql/mysql_priv.h @@ -593,11 +593,6 @@ protected: #define OPTIMIZER_SWITCH_LAST (1ULL << 26) /* The following must be kept in sync with optimizer_switch_str in mysqld.cc */ -/* -TODO: Materialization is off by default to mimic 5.1/5.2 behavior. -Once cost based choice between materialization and in-to-exists should be -enabled by default, add OPTIMIZER_SWITCH_MATERIALIZATION -*/ #define OPTIMIZER_SWITCH_DEFAULT (OPTIMIZER_SWITCH_INDEX_MERGE | \ OPTIMIZER_SWITCH_INDEX_MERGE_UNION | \ OPTIMIZER_SWITCH_INDEX_MERGE_SORT_UNION | \ @@ -605,6 +600,7 @@ enabled by default, add OPTIMIZER_SWITCH_MATERIALIZATION OPTIMIZER_SWITCH_INDEX_COND_PUSHDOWN | \ OPTIMIZER_SWITCH_TABLE_ELIMINATION | \ OPTIMIZER_SWITCH_IN_TO_EXISTS | \ + OPTIMIZER_SWITCH_MATERIALIZATION | \ OPTIMIZER_SWITCH_PARTIAL_MATCH_ROWID_MERGE|\ OPTIMIZER_SWITCH_PARTIAL_MATCH_TABLE_SCAN|\ OPTIMIZER_SWITCH_JOIN_CACHE_INCREMENTAL | \ |