Five reasons why I avoid database query hints

I know that some will disagree with me on this but I have never been a fan of query hints.

Most database vendors give you the ability to override the query optimizer with hints that you specify in a query. Each query can be executed in a variety of ways by the…