db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Optimizer work/issues/discussions....
Date Mon, 02 Oct 2006 17:17:13 GMT
Hi Bryan,

A modest first step might be to output the plans in xml. The ouptut 
could then be post-processed into the format needed by your favorite 
graph visualization tool. Even just pulling the xml into your browser 
might be more readable than what we have today.

Regards,
-Rick

Bryan Pendleton wrote:

>> good time to start some discussion around the various issues in the 
>> current Derby optimizer
>
>
> One place I struggle is that I find logged query plans to be rather
> intimidating and hard to read. I've been thinking that it might be
> useful to put some effort into either improving the output of the query
> plan dumper, or perhaps coming up with some other tools for displaying
> and analyzing query selection behaviors.
>
> Is there prior art here that we can re-use? Are there good examples of
> tools which analyze and visualize query execution strategies that we
> can learn from and borrow?
>
> thanks,
>
> bryan
>


Mime
View raw message