When I was taking a C++ class in college, for a short time we had access to
a really powerful X debugger (running on HPUX) that not only allowed one to
step through code but depicted the state of any watched objects (variables,
pointers, classes, etc) as a linked box with all relevant details
(addresses, values, members, etc). I really miss that tool.
Is there anything related for stepping through SQL? *Not *PL/SQL, mind you.
I am looking for a tool that can show me, graphically, how access predicates
get rowids out of an index, which are then passed up to a table access with
a filter predicate, then passed into a nested loop operation as a driving
rowsource which dictates the rows wanted from the 2nd child operation. I
want to see data; which rows were gotten and why, one row at a time. I am
sure we have all see powerpoint slides that show us this detail one painful
click at a time, but what about a run-time tool? Direct memory attach
programs come to mind, but they usually do not cater to the same audience
for some strange reason (*grin*). The audiences I have in mind are in
classroom settings, teaching Jr. DBAs and developers; I doubt any
experienced DBA would admit to wanting something like this. But I do. =)
PS - I did look around on google, but the hits were not promising. I was not
able to find much information about Visual SQL 4.2 (seems old), nor the MS
Visual Studio series - nothing in my quick driveby on the information
superhighway really satisfied me.