Dealing with High Concurrency with Table Hints

  • Comments posted to this topic are about the item Dealing with High Concurrency with Table Hints

  • So, the READPAST hint is potentially useful to prevent blocking, and the risk is that not all records that are expected to be affected, will be affected by the logic of the SQL statement.  Am I on the right track?

  • You're on the right track. But note that, like it's highlighted on the documentation, because the SQL Server query optimizer typically selects the best execution plan for a query, it's recommend that hints be used only as a last resort by experienced developers and database administrators.

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

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