1
SET SESSION storage_engine=pbxt;
2
CREATE TABLE t1 (a int primary key);
3
insert into t1 values (1),(2);
4
insert into t1 values (3),(4);
5
insert into t1 values (5),(6);
6
insert into t1 values (7),(8);
7
insert into t1 values (9),(10);
8
explain select * from t1;
9
id select_type table type possible_keys key key_len ref rows Extra
10
1 SIMPLE t1 index NULL PRIMARY 4 NULL 10 Using index