mysql存储引擎介绍及优化幻灯片.pptVIP

MySQL 技巧分享 索引实践 MySQL 技巧分享 函数和索引 MySQL 技巧分享 使用 UNION 来取代 IN 和 OR 原SQL：select * from city where id in (1,3,4) 或 select * from city where id = 1 or id = 3 or id = 4 explain 结果：id select_type table type possible_keys key key_len ref rows Extra 1?? SIMPLE? city?ALL? PRIMARY? NULL NULL? NULL 5? Using where 修改后SQL：SELECT * FROM city where id = 1 UNION ALL SELECT * FROM city where id = 3 UNION ALL SELECT * FROM city  explain 结果：id?? select_type table??????? type possible_keys key????? key_len ref?? rows Extra 1??? PRIMARY????? city???????? const PRIMARY?????? PRIMARY 4?????? const 1