I was trying to set up a foreign key for an id field but found out that some
of the ids are not in the referenced table. To look things up, I tried
select id from btable where id not in (select id from atable)
The query just hang..... My tables are pretty big (200, 000?) can anyone
help me to pinpoint the problem?
Thanks!