In my Advanced DBI tutorials I have a old screenshot of Alan
Burlison's explain tool:
http://search.cpan.org/doc/TIMB/DBI_Talk5_2001/sld014.htm
(It looks a little better before PowerPoint crunches it into 800x600).
Sadly what the image shows isn't very clear as it was taken while
Alan was working in the performance tuning group at Sun and shows
some heavily hinted Oracle Parallel Server queries.
I was wondering if someone could use ora_explain (supplied with
DBD::Oracle) on their system and send me some screenshots.
Ideally one of the "SQL Cache" window showing a query and then
another with the "explain" window showing the plan for the same
query.
Thanks!
Tim.
p.s. Please send to me direct, not to the list. And soon would be
handy as I'm finishing up preparing for this years conference!