You are optimizing several complex queries. You have determined that you can improve performance by always merging 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: 15483 | Points: 40
Select from following answers:
  1. MERGE UNION
  2. CONCAT UNION
  3. HASH UNION
  4. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

Login to post response