Home Forums SQL Server 7,2000 SQL Server Newbies COUNT and NULL RE: COUNT and NULL

  • April 30, 2008 at 12:45 am

    #808820

    [font="Verdana"]

    Chirag (4/29/2008)

    Hi

    What about using a Left join instead of "OR". This will have a better execution plan.

    Do you mean, joining TableA to TableA with left outer join will give better performance than using or?

    Mahesh

    [/font]

    MH-09-AM-8694