There was an issue with earlier versions of Derby, that was supposed to have been fixed.
Even so, the performance of the IN clause where you have a large list is going to be an issue in most databases. _____ From: Peter Ondruška [mailto:[EMAIL PROTECTED] Sent: Sunday, October 05, 2008 3:12 PM To: Derby Discussion Subject: Re: Perfroamnce of IN ( ... list ... ) statements What Derby version is it? How does it perform if you re-create index on foo_id column? p. On Sun, Oct 5, 2008 at 10:07 PM, Tim Dudgeon <[EMAIL PROTECTED]> wrote: If I run a statement like this is Derby: SELECT COL1, COL2 FROM FOO WHERE FOO_ID IN ( 1, 31, ..... 4567) it seems unexpectedly slow. Its actually faster to retrieve each row individually using a for loop that it is to use the IN ( .. list ... ) clause. This seems strange. Thanks Tim
