Re: Derby Performance Problem

[Sunitha Kambhampati]

Prasenjit Sarkar wrote:

The statistics obtained do not shed much light on this issue.
I'm fairly new to Derby and would like some direction on how to proceed.

   

In case you have not tried, it might be useful to see what query plan 
Derby is choosing by setting the debug property 
derby.language.logQueryPlan=true. 
http://db.apache.org/derby/docs/dev/tuning/rtunproper43414.html

Thanks,
Sunitha.