When is it ok to use an Index Hint on a query in production code?
It's OK to do this only when a better solution doesn't exist.

As David Browne - Microsoft commented:


  If you were writing in another language you wouldn't think twice about telling the computer not just what to do by how to do it.  That's all an optimizer hint is.