SQL Server 2000 Table Hints

  • Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/RDyess/tablehints.asp

  • Nice article, I especially near the end where real world experience is discussed.  I personally would like to see real world comparison between nolock and readpast, but maybe that's another article.  

    In some places the article correctly attributes decision-making to the optimizer, but in a few places I think the article misleads by attributing optimization decisions to the Query Analyzer:  "Table Hint May Not Be Used By Query Analyzer", "the query analyzer will often choose ...", "the query analyzer's preference for indexed views...", and "Another reason the query analyzer may ignore...."  Substitute "optimizer" for "Query Analyzer" and problem goes away.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply