• Let us have a look at the transaction.

    Difficult to speak hypothetically.

    Not sure if you want the readers to block updates or not to block updates or if you want incrased concurrency.

    If you want higher concurrency, snapshot isolation might be good.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]