Does anyone know why this relatively simply update query takes several minutes? In fact, I don't even let it finish because it takes so long. In theory, this should be updating a single record, that of user ID 110.


update users set visited = visited -1 where uID in (select uID from logins
where entryPoint = 'Registration' and uID = 110);