Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 74533 invoked from network); 5 Oct 2004 17:45:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 5 Oct 2004 17:45:41 -0000 Received: (qmail 75172 invoked by uid 500); 5 Oct 2004 17:45:36 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 75113 invoked by uid 500); 5 Oct 2004 17:45:35 -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 74957 invoked by uid 99); 5 Oct 2004 17:45:34 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [204.146.167.214] (HELO Boron.MeepZor.Com) (204.146.167.214) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 05 Oct 2004 10:45:33 -0700 Received: from [9.30.40.116] (dmz-firewall [206.199.198.4]) by Boron.MeepZor.Com (8.11.6/8.11.6) with ESMTP id i95HjVv16663; Tue, 5 Oct 2004 13:45:32 -0400 Message-ID: <4162DD0F.5040901@Sourcery.Org> Date: Tue, 05 Oct 2004 10:42:39 -0700 From: Satheesh Bandaram User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development CC: Daniel John Debrunner Subject: Re: Query Optimization Tool References: <4161F6A1.9010208@debrunners.com> <4162D0F1.9040809@debrunners.com> In-Reply-To: X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 You might be able to set properties to stop after compiling a query and get its plan. (without executing the query) Take a look at GenericStatement.java in org.apache.derby.impl.sql package... Satheesh Sandeep A(asandeep@csa.iisc.ernet.in) wrote: > > >>What sort of input does PLASTIC expect to describe a query plan? > > >PLASTIC takes only the query and shows the plan diagram >All previous implementations of PLASTIC has exploited the facility in >DB2, ORACLE , SQL Server in which the plan is stored in either tables or >it will be returned to the user as ResultSet. In contrast to this in >derby, it won't stores the plan in tables. Moreover we will get the plan >info only after executing the query. This is the major issue which we are >looking for now. > >regards >sandeep > > > > > >On Tue, 5 Oct 2004, Daniel John Debrunner wrote: > > It would be best to discuss this on the Derby developer list. > > What sort of input does PLASTIC expect to describe a query plan? > > Dan. > > > Sandeep A(asandeep@csa.iisc.ernet.in) wrote: > > >hello dan, > >Iam doing a miniproject as a part of my course to implement PLASTIC in > >derby first outside the engine then to inside the engine. > >PLASTIC is a recent approach to avoid optimization through query > >clustering. > >It has facilities to view plan diagrams in DB2,ORACLE and SQL SERVER. we > >should add the same facility for derby connections also. > >We are looking to modify the code to do as such. > >Any suggestions?? > > >regards > >Sandeep > > > >A.Sandeep > >http://people.csa.iisc.ernet.in/~asandeep > > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBYt0PENVNIY6DZ7ERAs5OAJ9DGaalZAS2sU6DRjVBm01D8GCf8ACdFrXt mLhBX2f5Ei0fZSqxkSCkXNE= =uCeu -----END PGP SIGNATURE-----