Home Forums SQL Server 2005 SQL Server 2005 General Discussion any way this can avoid of index scan? RE: any way this can avoid of index scan?

  • July 17, 2013 at 6:25 am

    #1633218

    Thank you Gail & Chris for explain.

    Just checked my tables and the "col1" on both table are non null. So it seems it's unavoidable.