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.


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

View raw message