mysql betwenn and的优化
mysql> show profiles;+----------+------------+------------------------------------------------------
--+
| Query_ID | Duration | Query
|
+----------+------------+------------------------------------------------------
--+
| 1 | 0.00043675 | select> |
| 2 | 0.08359450 | select> 0 |
+----------+------------+------------------------------------------------------
id列上有索引，第一种会索引范围扫描，第二种是全表扫描
页:
[1]