Re: Perfroamnce of IN ( ... list ... ) statements

[Tim Dudgeon]

Peter Ondruška wrote:

What Derby version is it?
How does it perform if you re-create index on foo_id column?

The column in the primary key column, so has an index.

Tim

p. On Sun, Oct 5, 2008 at 10:07 PM, Tim Dudgeon <[EMAIL PROTECTED] <mailto:[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