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
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