EVOLUTION-MANAGER

Edit File: multi_range_read_disk_sweep.result

DROP TABLE IF EXISTS integers; SET optimizer_switch='mrr_cost_based=off'; CREATE TABLE integers ( id INT PRIMARY KEY AUTO_INCREMENT, value INT, KEY (value) ) COMMENT='engine "InnoDB"'; INSERT INTO integers (value) VALUES (0), (1), (2), (3); EXPLAIN SELECT * FROM integers WHERE value IN (0, 2); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE integers range value value 5 NULL 2 Using where; Using MRR SELECT * FROM integers WHERE value IN (0, 2); id value 1 0 3 2 DROP TABLE integers;