执行一段insert into TableA select from TableB
看Message如下：
SQL Server Execution Times:
CPU time = 0 ms,elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms,elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 6 ms, elapsed time = 6 ms.
SQL Server Execution Times:
CPU time = 464857 ms,elapsed time = 75130 ms.
(211454 row(s) affected)
SQL Server Execution Times:
CPU time = 464857 ms,elapsed time = 75139 ms.
SQL Server Execution Times:
CPU time = 464857 ms,elapsed time = 75141 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
请问
1.这个CPU time和elapsed time的具体含义？相互之间的关系？
2.好像分了很多段？这个是和执行计划相对应的么？从上到下，对应执行计划的从左到右？ |
