Explore the SQL query table hint READPAST
SQL Shack
NOVEMBER 14, 2020
SQL Server creates an optimized execution plan based on the available inputs such as statistics, indexes. By default, it chooses a cost-optimized execution plan and executes the query. Sometimes, we use SQL queries table hints to override the default mechanism. Developers popularly use WITH (NOLOCK) query hint in a Select statement to avoid blocking issues. […].
83 
Let's personalize your content