STATISTICS TIME in queries
A friend is writing a training course on how the command STATISTICS TIME can be used to tune query performance and asks for your help to complete a presentation. He requires two queries that return NBA team details where the host city had a 2017 population of more than two million.
NBA team details can be queried from the NBA Season 2017-2018 database and city populations can be queried by adding in tables from the Earthquakes database.
Each query uses a different filter on the Teams table.
Query 1
- Filters the
Teamstable usingINand three sub-queries
Query 2
- Filters the
Teamstable usingEXISTS
This exercise is part of the course
Improving Query Performance in SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
___ ___ ___ ___ -- Turn the time command on