SQL Server parse and compile time: CPU time =0 ms, elapsed time =1 ms. SQL Server parse and compile time: CPU time =0 ms, elapsed time =17 ms. Table 'accounts'. Scan count 1, logical reads 23751, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. SQL Server Execution Times: CPU time =6281 ms, elapsed time =48701 ms. SQL Server Execution Times: CPU time =6281 ms, elapsed time =48474 ms. SQL Server parse and compile time: CPU time =0 ms, elapsed time =1 ms. SQL Server Execution Times: CPU time =0 ms, elapsed time =1 ms.
但是最后他寻求到了一个更好的办法:
ALTERTABLE accounts2 ADD id INT GO DECLARE@idINT SET@id=0 UPDATE accounts2 SET@id= id =@id+1 GO
统计信息如下:
SQL Server parse and compile time: CPU time =0 ms, elapsed time =247 ms. SQL Server Execution Times: CPU time =0 ms, elapsed time =1 ms. Table 'accounts2'. Scan count 1, logical reads 26384, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. SQL Server Execution Times: CPU time =4781 ms, elapsed time =4856 ms. (100000 row(s) affected) SQL Server parse and compile time: CPU time =0 ms, elapsed time =1 ms. SQL Server Execution Times: CPU time =0 ms, elapsed time =1 ms.