David Zonsheine wrote:
Sunitha Hi,
Where can I find the derby.properties?
The text file /derby.properties/ contains the definition of properties, or configuration parameters valid for the entire system. This file is not automatically created; if you wish to set Derby properties with this file, you need to create it yourself.
more in this link http://incubator.apache.org/derby/manuals/develop/develop12.html#IDX509
Sunitha.
Thanks, David
-----Original Message----- From: Sunitha Kambhampati [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 6:25 PM To: Derby Development Subject: Re: How to optimize the query
David Zonsheine wrote:
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=trueWe tried to see the index usage but couldn't.
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.
