Creating explain snapshots

To display an access plan graph, Visual Explain requires the information contained in an explain snapshot. Explain snapshots are stored in explain tables.

If you have not already created explain snapshots, you can create them using one of the following methods:

• Use the sample snapshots provided. For information about how to load these, see Using sample snapshots.

• Use the instructions in either of the following sections:
  • Creating explain snapshots for dynamic SQL statements.
  • Creating explain snapshots for static SQL statements.

• Use the Explain SQL function in Visual Explain. This function creates explain tables, if they do not exist; creates an explain snapshot for a dynamic SQL statement; and displays the resulting access plan graph for the snapshot.