So the moral of the story is that out of 15 years of SQL Server expreience, a query index hint was chosen as the solution 2 times! Just think about how many queries that the both of us have written where the idea of using an index hint wasn't even on the radar.....definately the exception and not the rule.