Tuning Indexes - Professional SQL Server 2005 Performance Tuning - page 375

Table '#boys'.
Scan count 0, logical reads 1003, physical reads 0, read-ahead reads 0, lob logi-
cal reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'people'.
Scan count 1, logical reads 1824, physical reads 0, read-ahead reads 1904, lob logi-
cal reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 63 ms, elapsed time = 1197 ms.
(1000 row(s) affected)
Table '#girls'.
Scan count 0, logical reads 1003, physical reads 0, read-ahead reads 0, lob logi-
cal reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'people'.
Scan count 1, logical reads 1897, physical reads 0, read-ahead reads 64, lob logi-
cal reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 46 ms, elapsed time = 866 ms.
(1000 row(s) affected)
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 1 ms.
Table '#boys'.
Scan count 1, logical reads 4, physical reads 0, read-ahead reads 0, lob logi-
cal reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 1 ms.
Table
'#girls___________________________________________________________________________
_________________________________________0000000000A0'. Scan count 1, logical
reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physi-
cal reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 1 ms.
Table 'people'.
Scan count 2, logical reads 32281, physical reads 0, read-ahead reads 14172, lob log-
ical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'.
Scan count 1, logical reads 5, physical reads 0, read-ahead reads 0, lob logi-
cal reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 813 ms, elapsed time = 8350 ms.
(1 row(s) affected)