Re: Performance of request of type WHERE ... IN ( ... )

From: Barry Lind <blind(at)xythos(dot)com>
To: Th Templ <templ_th(at)hotmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Performance of request of type WHERE ... IN ( ... )
Date: 2003-01-13 18:03:12
Message-ID: 3E22FF60.9010808@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

This is not a jdbc question. You should ask this on either the
pgsql-sql, pgsql-general or pgsql-performance mail lists. This has been
discussed many times in the past, so it also might be a good idea to
check the mail archives of those lists.

--Barry

Th Templ wrote:
> Hello,
>
> I have performance problem of an request of type ... WHERE ... IN ( ... ).
> How to improve performance of this type of request when a group of id in
> the 'in' is important.
> Thanks for your answers.
> Templth
>
>
>
>
>
> _________________________________________________________________
> MSN 8: advanced junk mail protection and 2 months FREE*.
> http://join.msn.com/?page=features/junkmail
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-01-13 18:05:51 Re: No class found for refcursor
Previous Message Barry Lind 2003-01-13 17:46:21 Re: Security manager changing the jdbc Connection class?