1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
set default_storage_engine='tokudb';
drop table if exists t2970;
Warnings:
Note 1051 Unknown table 'test.t2970'
create table t2970 (a int, b int, c int, d int, key(a), key(a,b));
insert into t2970 values (1,1,1,1),(1,2,3,4);
explain select a,count(b),max(b) from t2970 where a > 0 group by a order by a;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t2970 index a,a_2 a_2 10 NULL 2 Using where; Using index
alter table t2970 engine=tokudb;
explain select a,count(b),max(b) from t2970 where a > 0 group by a order by a;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t2970 index a,a_2 a_2 10 NULL 2 Using where; Using index
drop table t2970;
|
