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?
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.
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.
http://sqlserver-qa.net/blogs/sql2008/archive/2009/01/09/4894.aspx fyi and you can use plan guides in SQL.
