I've been working on this program that does a jopin on two large tables (50K plus records, about 110 characters in length each). Here's the join command:
select p.ID, p.email, p.name, c.secret from persons p left join collection c on c.pID = p.ID WHERE c.status = 'ok' AND c.lID = 111;
Pretty straight-forward stuff. Yet it's causing the database to hang on those two tables indefinitely. I can't use them in any way until they are unlocked. This join was working before and now it causes this problem all of a sidden. Any ideas what's up?
select p.ID, p.email, p.name, c.secret from persons p left join collection c on c.pID = p.ID WHERE c.status = 'ok' AND c.lID = 111;
Pretty straight-forward stuff. Yet it's causing the database to hang on those two tables indefinitely. I can't use them in any way until they are unlocked. This join was working before and now it causes this problem all of a sidden. Any ideas what's up?