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 12:03:47 GMT
Kristian Waagan wrote:
> On 06.10.08 10:53, Tim Dudgeon wrote:
>> 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.
> 
> Hello Tim,
> 
> It would be helpful to know if compressing the table helps (or 
> re-creating the index). The idea is to update the statistics used by the 
> optimizer.
> 
> I saw the question in an earlier post, but no reply. Which version of 
> Derby are you using?

As I mentioned in separate response, this is in fact much improved in 
letest Derby compared with what I was used to.

No need to persue any further.
Sorry for the confusion.

Tim


> 
> 
> regards,


Mime
View raw message