USE LEFT/JOIN instead of WHERE IN possibly would improve the performance..
On Tue, Feb 2, 2010 at 5:51 PM, fida aljounaidi
<fida(dot)aljounaidi(at)gmail(dot)com> wrote:
> Hi
>
> I have an sql query which takes 20 seconds to be executed.
>
> this sql query contain more than 870 id under the select where in ()
> condition.
>
> So , it is not a large row result but a big list of conditions to be
> crossed.
>
> I'm using postgresql 8.4.
>
> Thanks for help
>
>
>
--
Regards,
Kiswono P
GB