Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Message-ID: <4175555F.1040007@Yngvi.Org>
Date: Tue, 19 Oct 2004 10:56:47 -0700
From: Sunitha Kambhampati <skambha@Yngvi.Org>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
MIME-Version: 1.0
To: Derby Development <derby-dev@db.apache.org>
Subject: Re: How to optimize the query
References: <58D63E44CFC6D3119C8C009027E02DFD07B0A86D@tlvmail.enigma.co.il>
In-Reply-To: <58D63E44CFC6D3119C8C009027E02DFD07B0A86D@tlvmail.enigma.co.il>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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: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.
>
>  
>