Home Forums SQL Server 2008 T-SQL (SS2K8) Index requirement for logical operations RE: Index requirement for logical operations

  • March 4, 2011 at 1:19 am

    #1294485

    GilaMonster (3/4/2011)

    Move year from the include to the key. I didn't notice the filter on that earlier

    I moved 'year' to the key column in both the indexes but still the same execution plan with non-clustered index scan