Following along interactively with Query 3

To follow along interactively with Query 3 (the basic query after creating indexes on join predicates and running runstats), display the access plan graph for it. This snapshot is identified by the number 5 under Query Number in the Explained Statements History window.

The following SQL statements were used to create the indexes:

CREATE INDEX I_DEPT     ON STAFF (DEPT)
CREATE INDEX I_DEPTNUMB ON ORG   (DEPTNUMB)

You can use the Control Center to create indexes.

After creating a new index, collect statistics for that index (using the runstats command with the INDEXES clause) and create an explain snapshot.

For more information, see the section on creating an index in the Administration Guide.

To display the Operator Details for FETCH (13) or FETCH (17), double-click on either of these nodes in the graph.

To display the Operator Details for FETCH (9) or FETCH (25), double-click on either of these nodes in the graph.