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 database 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...