• 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