EVOLUTION-MANAGER

Edit File: optimization_count_skip_index_and.result

DROP TABLE IF EXISTS users; FLUSH STATUS; CREATE TABLE users ( id INT, age INT, INDEX (id, age) ) DEFAULT CHARSET=UTF8; INSERT INTO users (id, age) VALUES (1, 28); INSERT INTO users (id, age) VALUES (1, 28); INSERT INTO users (id, age) VALUES (1, 29); INSERT INTO users (id, age) VALUES (2, 29); INSERT INTO users (id, age) VALUES (2, 29); INSERT INTO users (id, age) VALUES (3, 29); SELECT COUNT(*) FROM users WHERE id = 2 AND age = 29; COUNT(*) 2 SHOW STATUS LIKE 'mroonga_count_skip'; Variable_name Value Mroonga_count_skip 1 DROP TABLE users;