1.2 How Query Hints Reduce the Stench
In our last module, we hit a wall when we tried to use index tuning to solve a problem where SQL Server had to choose between two different indexes for the same table. Sometimes a date range was more selective, and sometimes a score was more selective. When you’re facing the problem of which index…
