September 27, 2009 at 10:09 am
Hi
I have read about readpass hints. I have a join in which the table which works for the app as queue is being used. can I use the readpass hint in the inner join. Looks to me, the same should not create any issues. At the moment, cant test the same so just trying to get some views on the same.
cheers
Siddarth
September 28, 2009 at 3:13 am
From Books Online:
READPAST
Specifies that the Database Engine not read rows that are locked by other transactions. Under most circumstances, the same is true for pages.
If you're happy that your query will completely ignore locked rows and pages and potentially return different data if run multiple times, go ahead and use it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply