• left outer joins don't necessarily lock the table. Would like to know where you read that, since it's wrong.

    The outer joins often scan the whole table because you may end up with pulling a large percentage of rows if there aren't other restrictions, so that can be an issue.

    I'd look at code first, locks next.