db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject Re: Perfroamnce of IN ( ... list ... ) statements
Date Mon, 06 Oct 2008 08:53:24 GMT
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 
> <tdudgeon@informaticsmatters.com 
> <mailto:tdudgeon@informaticsmatters.com>> 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
> 
> 


Mime
View raw message