1. 学习
    2. /
  2. 课程
    3. /
  3. Improving Query Performance in SQL Server
Connected

练习

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.

说明 1 / 共 3 个

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