建一个简单的测试表
代码
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
–>CREATE TABLE ExcuteTime
(
[Type] VARCHAR(10), –不同COUNT类型
[CpuTime] FLOAT –语句执行的毫秒
)
代码
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
–>–得到COUNT(1)100次的执行时间
DECLARE @BeginTime DATETIME;
DECLARE @Num INT;
SET @Num = 1;
WHILE @Num <= 100
BEGIN
SET @BeginTime = GETDATE();
SELECT COUNT(1) FROM Employee;
INSERT INTO ExcuteTime
VALUES(‘Count(1)‘, DATEDIFF(ms, @BeginTime,GETDATE()));
SET @Num = @Num + 1;
END
GO