SQL Server Performance

Index Hint

Discussion in 'Getting Started' started by lcerni, Nov 12, 2009.

  1. lcerni New Member

    You can use a index hint to force a query to use a particular index. Is there a method to force a query not to use a particular index?
  2. Adriaan New Member

    Theoretically, you could add non-sargeable nonsense criteria for (one of) the indexed column(s) -
    WHERE LEFT(column, LEN(column)) = RIGHT(column, LEN(column))
    If you need to bypass this index frequently, then you should consider adding another index that supports your queries better.
  3. FrankKalis Moderator

    The thing is, that such a predicate will most likely not use any index, which probably is not what is wanted here.
    I might be wrong, but I don't think there is a way to force SQL Server NOT to use a particular index.
  4. satya Moderator

Share This Page