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
