db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: Query Optimization Tool
Date Tue, 05 Oct 2004 01:19:29 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jonas S Karlsson wrote:

> Sunitha Kambhampati <skambha@yngvi.org> wrote:
>
>>It is not very user friendly, but it helps to give an idea of which
>>indexes have been used.
>
>
> Yes, reading that very wide output is a lot of fun, so fun that I
> wrote a script to do it a while back, it picks out the major structure
> of the query, gives some index/join info of the plan and shows the
> general outline. My query had 15 nested joins so it was really
> impossible to read the output by hand. You may need to modify it
> for your queries...

The TO-DO list has this entry

Generate run time statistics output in XML format

[http://incubator.apache.org/derby/DerbyToDo.html]

A regular format for the output would be a great help to everyone, an
XML format seems natural. As far as I know no-one is working on this,
though maybe what Sandeep is doing is similar.

Sandeep, is there any chance you could give an overview of what you are
doing?

I'm hoping that work in this area could reduce Derby's footprint by
removing the specialized classes in the
org.apache.derby.impl.sql.execute.rts package.

Dan.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBYfahIv0S4qsbfuQRAga3AJ48COY5wuu0PliztjEBnlTXl9ryEgCfYrwx
dSMIMPKuiyoT3iACs12AdYg=
=1/t7
-----END PGP SIGNATURE-----


Mime
View raw message