anthony.green (12/12/2012)

---

What is the output with statistics time switched on and also what do the executions plans show.

SQL Server parse and compile time:

CPU time = 16 ms, elapsed time = 30 ms.

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

full text

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

Table 'Person_BK'. Scan count 0, logical reads 30634, 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 = 500 ms, elapsed time = 1516 ms.

nomral

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

Table 'Person_BK'. Scan count 1, logical reads 16216, 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 = 1094 ms, elapsed time = 2648 ms.