offering. We have recently modified a query by adding a couple of tables to a simple join. We have noticed a drastic increase in query compilation time on large data sets.
It's possible you're seeing this problem: https://issues.apache.org/jira/browse/DERBY-2130
There is an experimental patch attached to that issue. If possible, in your environment, it would be interesting if you can confirm whether the patch improves the behavior that you see. thanks, bryan
