SQLServer 2000 升级到 SQLServer 2008 性能之需要注意的地方之一

测试sql: 代码如下: SET STATISTICS IO ON SET STATISTICS TIME ON SELECT COUNT(1) FROM dbo.tbtext a INNER LOOP JOIN dbo.tbtext b ON a.id = b.id option (maxdop 1) SET STATISTICS IO Off SET STATISTICS TIME Off 表结构: 代码如下: CREATE TABLE [dbo].[tbtext]( [id] [int] IDENTITY(1,1) NOT NULL, [VALUE] [int] NULL ) ON