db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Klebanoff <kleba...@Mutagen.Net>
Subject Re: How to optimize the query
Date Tue, 19 Oct 2004 17:52:06 GMT
You can find derby.properties in the directory named by system property 
derby.system.home, or the working directory where you started derby if 
derby.system.home is not defined.

Jack Klebanoff
David Zonsheine wrote:

>Sunitha Hi,
>
>Where can I find the derby.properties?
>
> 
>Thanks,
>David
>
>-----Original Message-----
>From: Sunitha Kambhampati [mailto:skambha@Yngvi.Org]
>Sent: Tuesday, October 19, 2004 6:25 PM
>To: Derby Development
>Subject: Re: How to optimize the query
>
>
>
>David Zonsheine wrote:
>
>  
>
>>We tried to see the index usage but couldn't.
>>
>>    
>>
>did you try to set the property derby.language.logQueryPlan=true in your 
>derby.properties file or you can also set it as  a java property  
>-Dderby.language.logQueryPlan=true
>
>This property when set will print the query plans  in derby.log  
>
>If an index is used, you will be able to see  IndexScan ResultSet....
>
>an example :
>here my tablename is SCANFIXED and index is SCANFIXEDX...
>
>[snip]
>    Index Scan ResultSet for SCANFIXED using index SCANFIXEDX at read 
>committed isolation level using instantaneous share row locking chosen 
>by the optimizer
>[snip]
>
>
>Sunitha.
>--------------------------------------------------------------------------------------------------------------------------------------------------------------
>This email and any files transmitted with it are confidential and intended solely for
the use of the individual or entity to whom
>they are addressed. If you have received this email in error please notify the originator
of the message.
>Scanning of this message is performed by SurfControl E-mail Filter software in conjunction
with  virus detection software.
>
>  
>


Mime
View raw message