运算符与> = AND< =之间:是否存在性能差异? [英] BETWEEN operator vs. >= AND <=: Is there a performance difference?
本文介绍了运算符与> = AND< =之间:是否存在性能差异?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
这两个语句在逻辑上是等效的:
These two statements are logically equivalent:
SELECT * FROM table WHERE someColumn BETWEEN 1 AND 100
SELECT * FROM table WHERE someColumn >= 1 AND someColumn <= 100
一个相对于另一个是否有潜在的性能优势?
Is there a potential performance benefit to one versus the other?
推荐答案
没有好处，只是语法糖.
No benefit, just a syntax sugar.
通过使用BETWEEN版本，在某些情况下可以避免函数重新评估.
By using the BETWEEN version, you can avoid function reevaluation in some cases.
这篇关于运算符与> = AND< =之间:是否存在性能差异?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
