This worked fine but it�s not de ideal solution
since i may have more than 2 id_mailing (8,9,34,234,434).
But it helped.
Thanks a lot.

"Bill Katelis" <bill@...> escreveu na mensagem
news:3D508CA9.8010204@......

> try this :
>
> Select Cliente.Nome
> From Cliente,Cliente_Mailing Where
> (Cliente_Mailing.id_mailing=8)
> and Cliente.id_cliente=Cliente_Mailing.id_cliente
> union
>
> Select Cliente.Nome
> From Cliente,Cliente_Mailing Where
> (Cliente_Mailing.id_mailing=9)
> and Cliente.id_cliente=Cliente_Mailing.id_cliente
> order by 1;
>
>
> bill
>
> las19682000 wrote:
>
> >Hi, i have about 400,000 records on my table Cliente and about
> >400,000 on
> >Cliente_Mailing and when i run this query:
> >
> >Select Cliente.Nome
> > From Cliente,Cliente_Mailing Where
> > (Cliente_Mailing.id_mailing=9 or Cliente_Mailing.id_mailing=8)
> > and Cliente.id_cliente=Cliente_Mailing.id_cliente
> > Order by nome
> >
> >It Takes about 24 minutes
> >
> >But if i test only Cliente_Mailing.id_mailing=9 like this:
> >Select Cliente.Nome
> > From Cliente,Cliente_Mailing Where
> > (Cliente_Mailing.id_mailing=9)
> > and Cliente.id_cliente=Cliente_Mailing.id_cliente
> > Order by nome
> >
> >it takes 1 second
> >
> >Why and how to speed the top query
> >Thanks
> >
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@egroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>