Home Forums SQL Server 7,2000 Performance Tuning Using 'WITH(NOLOCK) to Improve Performance. RE: Using 'WITH(NOLOCK) to Improve Performance.
Andy Warren
SSC Guru
Points: 119747
More actions
June 9, 2003 at 7:22 am
#460348
I don't think the hint hurts you. Easy enough to test a few times with/without. Probably need to revisit the query plan, see what can be tweaked.
Andy
http://qa.sqlservercentral.com/columnists/awarren/
Andy SQLAndy - My Blog! Connect with me on LinkedIn Follow me on Twitter