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

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response