Home Forums SQLServerCentral.com Editorials Searching for Plans RE: Searching for Plans
Dave Ballantyne
SSC-Dedicated
Points: 33566
More actions
September 13, 2010 at 1:29 am
#1219868
Personally, i would like an "OPTIMIZE FOR (CONCURRENT) " option.
In an ideal world this would create a plan that executes more slowly , but touch fewer rows and therefore reduce (b)locking and allow more tasks to execute.