STATISTICS IO comparison
Using the STATISTICS IO
outputs from the example queries in the previous two exercises, what might you conclude?
Example 1
Table 'Customers'. Scan count 1, logical reads 2, physical reads 0,....
Table 'Orders'. Scan count 2, logical reads 32, physical reads 0,...
Example 2
Table 'Customers'. Scan count 1, logical reads 2, physical reads 0,....
Table 'Orders'. Scan count 2, logical reads 16, physical reads 0,...
This exercise is part of the course
Improving Query Performance in SQL Server
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
