Re: query slow problem

>
> On Mon, 29 Jul 2002, frank_lupo wrote:
>
> > select id,de2 from irtab where id in (select distinct(ruolofunz)
from
> > irelbtes_1 where entpian=118331)\g
>
> In optimizes poorly currently in postgres, so you're generally better
> off converting to EXISTS or subselect in FROM. Something like
> (untested):
>
> select id, de2 from irtabl where exists (select 1 from
> irelbtes_1 where entpian=118331 and irtabl.id=ruolofunz)
>
> or
>
> select id, de2 from irtabl, (select distinct(ruolofunz) as r from
> irelbtes_1 where entpian=118331) as i
> where i.r=irtabl.id;
>
>
>
>
>

My problem is not resolved.

Thank

Bye !!
Frank Lupo (Wolf) !!

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Paura delle Eurobanconote false? Clicca qui
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=374&d=29-7