1. Learn
  2. /
  3. Courses
  4. /
  5. Improving Query Performance in SQL Server

Exercise

STATISTICS IO: Example 2

In the previous exercise, you were asked you to provide a new regional manager daily updates on orders shipped to Western Europe capital cities. You initially created a query that contained two sub-queries. You decide to do a rewrite and use an INNER JOIN.

The STATISTICS IO command is turned on. You will need to turn it off after completing the query.

Instructions 1/3

undefined XP
    1
    2
    3
  • Add the join operator.
  • Add the shipping destination city column in the filter condition.