You are optimizing several complex queries. You have determined that you can improve performance by hashing UNION sets.

Which of the following query hints should you use to implement this optimization?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 22249 | Points: 40
Select from following answers:
  1. HASH UNION
  2. HASH JOIN
  3. MERGE UNION
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response