db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunitha Kambhampati <skam...@Yngvi.Org>
Subject Re: Query Optimization Tool
Date Mon, 04 Oct 2004 16:19:15 GMT
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.


Mime
View raw message