*1.应尽量避免在WHERE子句中使用!=或 <>操作符,否则将导致引擎放弃使用索引而进行全表扫描.,应使用<,<=,>,>=,BETWEEN以及LIKE('a%') ① : 示例sql 反例 : EXPLAIN SELECT * FROM HIS_BOOK_REG WHERE ID != '2'; EXPLAIN SELECT * FROM HIS_BOOK_REG WHERE ID <> '2'; 应改为 : EXPLAIN SELECT * FROM HIS_BOOK_REG WHERE ID = '1' UNION ALL SELECT...