Get startedGet started for free

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?

This exercise is part of the course

Improving Query Performance in SQL Server

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise