Home Forums SQL Server 2005 SQL Server 2005 General Discussion defining query to use an existing index RE: defining query to use an existing index

  • February 13, 2011 at 10:36 pm

    #1286268

    You can specify table hints to specify use of a particular index.

    Select ID

    FROM TableA

    WITH (INDEX(TableA_NCI_ID))

    Check "Table Hints" in BOL.