1.未指定order by子句時(shí)，查詢結(jié)果受到檢索時(shí)使用到的索引影響；
SELECT TOP 10000 IDENTITY(INT ,1,1) AS Pkid ,o.* INTO tempTable FROM sys.objects o,sys.[columns] c
CREATE CLUSTERED INDEX ixuc_pkid ON tempTable(pkid ASC)
--CREATE CLUSTERED INDEX ixuc_pkid ON tempTable(pkid DESC)
DROP INDEX dbo.tempTable.ixuc_pkid
(1) SELECT * FROM tempTable tt
CREATE INDEX cxde_objid ON dbo.tempTable(OBJECT_ID)
(2) SELECT * FROM tempTable tt ORDER BY tt.OBJECT_ID
DROP INDEX dbo.tempTable.ixuc_pkid
(3) SELECT * FROM tempTable tt ORDER BY tt.OBJECT_ID
通過(guò)CTRL+L查看(1)(2)(3)查詢開(kāi)銷驗(yàn)證以上結(jié)論
2.指定order by子句時(shí),除非受到