Re: SQL WHERE: many sql or large IN()

Hi,

tom wrote:
> Initially it seems that the WHERE IN (...) approach takes a turn for the
> worse when the list gets very large.

What version do you use? PostgreSQL 8.2 had great improvements for that
specific issue. Did you try EXPLAIN?

Regards

Markus