请教一个 mysql 优化问题， BETWEEN AND 和大于小于哪个比较好呢

9xrtp7r1 · 2015-03-24T09:48:33Z

timeSS BETWEEN '2012-12-12 12:12:12' AND '2015-12-12 12:12:12' timeSS > '2012-12-12 12:12:12' AND timeSS < '2015-12-12 12:12:12' 这2个用哪个比较好呢

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 4066 days ago, the information mentioned may be changed or developed.

这2个用哪个比较好呢

2 replies • 2015-03-26 16:07:19 +08:00

huijiewei

Mar 24, 2015

理论上 BETWEEN AND 效率更高

9xrtp7r1

Mar 26, 2015

请教一个 mysql 优化问题， BETWEEN AND 和大于小于 哪个比较好呢