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,
