1
2
3
4
5
6
7
8
9
10
11
12
|
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
DROP TABLE IF EXISTS t;
CREATE TABLE t (r INT, s INT, t BIGINT, PRIMARY KEY (r, s));
INSERT INTO t VALUES (1,2,3),(4,5,6);
EXPLAIN SELECT * FROM t WHERE r > 0;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t range PRIMARY PRIMARY 4 NULL NULL; Using where
CREATE INDEX it on t(t);
EXPLAIN SELECT * FROM t WHERE r > 0;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t range PRIMARY PRIMARY 4 NULL NULL; Using where
DROP TABLE t;
|
