T-SQL 執行計畫中排序為最高成本的解決方法

SELECT FLD1, FLD2
FROM TABLE1
ORDER BY FLD3, FLD4

1.建立 Index
CREATE NONCLUSTERED INDEX NCI_TABLE1
ON TABLE1(FLD3, FLD4)
INCLUDE (FLD1, FLD2)

2.更新統計資訊
UPDATE STATISTICS TABLE1;