Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 32051 invoked from network); 19 Oct 2004 14:49:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 19 Oct 2004 14:49:01 -0000 Received: (qmail 56557 invoked by uid 500); 19 Oct 2004 14:48:28 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 56450 invoked by uid 500); 19 Oct 2004 14:48:27 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 56401 invoked by uid 99); 19 Oct 2004 14:48:26 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=HTML_60_70,HTML_MESSAGE,MIME_BOUND_NEXTPART X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from [192.115.235.3] (HELO mailgw.enigma.co.il) (192.115.235.3) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 19 Oct 2004 07:48:26 -0700 Received: from tlvmail.enigma.co.il [10.10.0.3] by mailgw.enigma.co.il - SurfControl E-mail Filter (4.7); Tue, 19 Oct 2004 16:48:21 +0200 Received: by tlvmail.enigma.co.il with Internet Mail Service (5.5.2657.72) id ; Tue, 19 Oct 2004 16:48:17 +0200 Message-ID: <58D63E44CFC6D3119C8C009027E02DFD07B0A868@tlvmail.enigma.co.il> From: David Zonsheine To: "'derby-dev@db.apache.org'" Date: Tue, 19 Oct 2004 16:48:15 +0200 Subject: How to optimize the query MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--=_NextPart_ST_16_48_22_Tuesday_October_19_2004_22107" X-Mailer: Internet Mail Service (5.5.2657.72) X-SEF-71F8950-145E-45E1-A736-C766A41A3B82: 1 X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ----=_NextPart_ST_16_48_22_Tuesday_October_19_2004_22107 Content-Type: text/plain; charset="windows-1255" Hello Derby Users We are going to use Derby as an embedded data base for thousands of applications we deliver to the market. However, we have a simple database with a not so easy query that takes about 0.016 seconds in Oracle and 2.5 sec in Cloudscape (Derby). I posted a question about hints and found out that there are no hints in Derby right now. We tried to see the index usage but couldn't. How can I optimize a query in Derby? How do you do it? Is there a tool? Is there a command line parameter? Please help. We want to use this database. David -------------------------------------------------------------------------------------------------------------------------------------------------------------- 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. ----=_NextPart_ST_16_48_22_Tuesday_October_19_2004_22107 Content-Type: text/html; charset="windows-1255" Content-Transfer-Encoding: quoted-printable

Hello&nbs= p;Derby=20 Users

We are go= ing to use=20 Derby as an embedded data base for thousands of applications we deliver to = the=20 market.

However, we have a simple dat= abase=20 with a not so easy query that takes about 0.016 seconds in Oracle and 2.5 s= ec in=20 Cloudscape (Derby).

I posted a question about hin= ts and=20 found out that there are no hints in Derby right now.<= /DIV>

We tried to see the index usa= ge but=20 couldn't.

How can I optimize a query in= Derby?=20 How do you do it? Is there a tool? Is there a command line=20 parameter?

Please help. We want to use t= his=20 database.

David

-= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= -------
This email and any files transmitted with it are confidential an= d intended solely for the use of the individual or entity to whom
they a= re addressed. If you have received this email in error please notify the or= iginator of the message.
Scanning of this message is performed by SurfCo= ntrol E-mail Filter software in conjunction with virus detection software.=
----=_NextPart_ST_16_48_22_Tuesday_October_19_2004_22107--