• 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.



    Clear Sky SQL
    My Blog[/url]