Josh Sacks <[EMAIL PROTECTED]> writes:
> I can't understand what's going on in this simple query:
If you are using anything older than PG 7.4, you should not expect good
performance from WHERE ... IN (sub-SELECT) queries. There's essentially
no optimization happening there.
I can't understand what's going on in this simple query:
select c.name from Candidate C where
C.candidate_id in (select candidate_id from REFERRAL R
where r.employee_id = 3000);
Where Candidate.CANDIDATE_ID is the primary key for Candidate.
Here's the EXPLAN ANALYZE:
Seq
