Oleg Bartunov [EMAIL PROTECTED] writes:
The best plan I've got eliminating IN predicate:
select msg_prt.tid as mid from msg_prt
where exists (select idx.tid from idx where msg_prt.tid=idx.tid
and idx.did=1 and idx.lid = 1207 and idx.lid=59587 )
Surely that returns zero rows?
Oleg Bartunov [EMAIL PROTECTED] writes:
should be
select msg_prt.tid as mid from msg_prt
where exists (select idx.tid from idx where msg_prt.tid=idx.tid
and idx.did=1 and ( idx.lid = 1207 or idx.lid=59587 ));
but this is not a big win.
Shouldn't be any win at all: the IN
