1. Avnish New Member

   Hi ,
   I have two queries having same output but differ in n the execution plan
   one using : Merge Join(Concatenation)
   second : Merge Join (UNION)
   Which Query is better ?
   Thanks!!

   Avnish, Apr 2, 2008

   #2
2. Luis Martin Moderator

   Check:
   http://www.mssqltips.com/tip.asp?tip=1387
   

   Luis Martin, Apr 2, 2008

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in