diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2018-12-09 13:25:27 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2018-12-09 13:25:27 +0530 |
| commit | 9207a838ededa0d5f40129848de20a2075ab0e44 (patch) | |
| tree | e26a6d34fbe62ee2fd84010965c20990787865d8 /sql-common | |
| parent | 93c360e3a53dbfe843bc4b769e73cbe9248cd5b3 (diff) | |
| download | mariadb-git-9207a838ededa0d5f40129848de20a2075ab0e44.tar.gz | |
MDEV-17255: New optimizer defaults and ANALYZE TABLE
Added to new values to the server variable use_stat_tables.
The values are COMPLEMENTARY_FOR_QUERIES and PREFERABLY_FOR_QUERIES.
Both these values don't allow to collect EITS for queries like
analyze table t1;
To collect EITS we would need to use the syntax with persistent like
analyze table t1 persistent for columns (col1,col2...) index (idx1, idx2...) / ALL
Changing the default value from NEVER to PREFERABLY_FOR_QUERIES.
Diffstat (limited to 'sql-common')
0 files changed, 0 insertions, 0 deletions