On 07/03/2012 03:20 PM, TXVanguard wrote:
Don't worry too much about the details: just look at the SELECT DISTINCT, the WHERE, the GROUP BY, etc. What are some general strategies for speeding up this kind of statement?
What the community knows about this sort of thing is mostly collected here: http://db.apache.org/derby/docs/10.9/tuning/ A good place to start is to (a) break down your big query into smaller queries, so you can analyze each part separately, and (b) learn how to read Derby's query execution plan output, which you can read about here: http://db.apache.org/derby/docs/10.9/tuning/ctundepth853133.html thanks, bryan
