Database Blog

  • Five reasons why I avoid database query hints

    Jul 28, 2010

    Reading Time: 2 minutes 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 the database engine. Normally, the optimizer evaluates the statistics about the data in each of the tables involved in the query and makes…..

    Read more Add new comment