• Are your statistics up to date? If not, then the query optimiser might not be able to make the correct decision about what type of lock to take for the SELECT statement. For instance, say your statistics were last updated when half of the contact names began with A, but now only one in 26 does. This might be why the locks are being escalated.

    John