sathiyan00 (9/6/2013)
i want the product which is there in both the brand not just in one
Right. That wasn't entirely clear from your original post.
I guess they're about the same performance (I haven't found an article or blog post that contradicts this). You can test it out with a large number of rows and compare execution plans and execution times.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP