When I look at the execution plan for a SELECT query, I often notice sorts thrown in there hogging CPU. The problem is that I don't have any order by's in my query, and it looks like the cause of the sorts are ascending/descending order set for the column on the index used in the query. When I look at the execution plan for a SELECT
阅读背景：
Sql Server隐式顺序执行计划
来源：互联网
分享到：
