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?

Bu egzersiz

Improving Query Performance in SQL Server

kursunun bir parçasıdır

Kursu Görüntüle

Uygulamalı interaktif egzersiz

İnteraktif egzersizlerimizden biriyle teoriyi pratiğe dökün

Egzersizi başlat