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,...
Latihan ini adalah bagian dari kursus
Improving Query Performance in SQL Server
Latihan interaktif praktis
Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.
Mulai berolahraga