David Zonsheine wrote:
We need the tool for a simple check of index usage and similiar checks.for simple checks to see if the query plan uses the right index or not , try setting the following property derby.language.logQueryPlan=true in derby.properties and run your app. The query plans will be printed in derby.log
It is not very user friendly, but it helps to give an idea of which indexes have been used.
Sunitha.
