Home Forums SQL Server 2012 SQL 2012 - General INDEX HINT or NO INDEX HINT RE: INDEX HINT or NO INDEX HINT

  • May 22, 2015 at 12:15 pm

    #1800118

    GilaMonster (5/22/2015)

    sql-lover (5/22/2015)

    And I discovered that the existing Index needs two more columns to make it cover.

    And you added two columns to the existing index? Or created a new one with two additional columns?

    Gail,

    I Added two more columns to the INCLUDED column list. That was my only change.

    Not at my PC right now but I think we have 3 NCIs. After that change, it picked another NCI but not the modified one. The modified one does a seek without the key lookup.

    I should also say that I refresh stats on the lab just to check the optimizer but keeps picking a different NCI.