SQL Server query issue using index hints
Posted on 2011-09-16
On one server, using an index hint made the sql go very fast as expected. So used the index hint. But the same query, on another database server, performed much slower. Funny thing was, when the index was removed, the query performed very fast. Why is that, and what can be done. This is a conflicting behavior, how to solve this issue. Are there any other settings to look at, if any experts have seen this.