“>= and <= ”等价于 “between and”，执行效率一样。但“> and <”不一样， “between and”包含该条件边界。
测试数据1000W
SELECT * FROM gearbox.t_data_1000 where uid between 1500 and 1600; 耗时3.246 sec
SELECT * FROM gearbox.t_data_1000 where uid >= 1500 and uid <= 1600; 耗时3.493 sec
SELECT * FROM gearbox.t_data_1000 where uid between 9991500 and 9991600; 耗时3.214 sec
SELECT * FROM gearbox.t_data_1000 where uid >= 9991500 and uid <= 9991600; 耗时3.294 sec
扫一扫
2088
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
