Following along interactively with Query 1

To follow along interactively with Query 1 (the basic query with no indexes and no statistics), you must display its access plan graph.

From the Control Center, open the Explained Statements History window and double-click on the explain snapshot for Query 1. This snapshot is identified by the number 1 under Query Number. The Access Plan Graph window opens, displaying the access plan graph for sample Query 1.

To see the statistics that are being used for the ORG table, double-click on the ORG table node in the graph. The Table Statistics window opens.

To view statistics for multiple tables in a graph (or indexes, if there are any), select each table node by clicking on it (the color changes); then select Node->Show statistics.