So far that one was the worst in terms of cost and time. Here are all the
plans with buffers, more records, and results being returned. At this point
I have good enough performance with my UNION approach but I'm just trying
to learn now. WHY is the union approach the fastest? I would have expected
On Thu, Nov 21, 2013 at 2:31 PM, desmodemone wrote:
> Hi Robert, could you try with "exists" ?
>
> SELECT c.*
> FROM contacts c
> WHERE exists ( SELECT 1 FROM phone p WHERE p.addr =? and
> p.contact_id=c.id )
> OR exists (SELECT 1 FROM email e WHERE e.addr = ? and e.contact_id=c.id );
hm, ho
Title: Assinatura de E-mail padrão Riosoft 20 anos
Hi,
What is
the maximum amount
of VM that
can be created?
Version 9.3
Tks,
--
