STATISTICS TIME results
In the previous exercise, the STATISTICS TIME command was used on two different queries. The following table summarizes an analysis of the elapsed time statistics for each query.
| Query | Details | Average elapsed time (ms) |
|---|---|---|
| 1 | Filters the Teams table using IN and three sub-queries |
20 |
| 2 | Filters the Teams table using EXISTS |
3 |
What conclusion can you make from this summary?
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