The problem is the result from this query returns me after 25 minutes later. Can anybody suggest anything about What the problem is?
It sounds like you're getting the results that you expect from your query, but it's taking much longer than you expect.
If that's true, than the problem is that the database is doing more work than you want it to, which you may be able to fix by adding indexes or restating your query. To start with, you're going to need to gather a lot more information. Here are some good places to start: http://db.apache.org/derby/docs/dev/tuning/ttundepth33391.html http://wiki.apache.org/db-derby/PerformanceDiagnosisTips thanks, bryan