SQL Server operands order

 

This question already has an answer here:

  • Does order of where clauses matter in SQL 6 answers

    • Theres isnt any difference, you db planner will parse the code and choose the better option.

    What is interesting is the order of execution can change if table sizes change. But how you write it wont.

    There might be a difference based on which indexes you have on the table. Check actual execution plan to see what sql decides to use

    链接地址: http://www.djcxy.com/p/44012.html

    上一篇: 生成的查询未达到最佳表格索引

    下一篇: SQL Server操作数顺序