Choosing from a list of explainable statements in a package

To display an access plan graph by choosing from a list of explainable statements, follow these steps:

1. In the Control Center, select the database you want and click on its expansion icon to see the objects it contains. Click on the Packages object (under the Application Objects folder). Any existing Package objects are displayed in the pane on the right side of the window (the contents pane).
   • Click mouse button 2 on the package that you want in the contents pane and select Show explainable statements from the pop-up menu. The Explainable Statements window opens.
2. To display other packages, select View->Filter, and change the filtering criteria.
3. Select one or more packages that have an explain snapshot (that is, one whose entry in the Explain Snapshot column is "Yes"), then select Selected->Show explainable statements (or use the pop-up menu).
4. The Explainable Statements window opens, listing all of the explainable statements in the selected packages, and whether or not explain snapshots exist for them.
5. To display the access plan graph for a single explain snapshot, you can double-click on a statement that has one (that is, one whose entry in the Explain Snapshot column is "Yes").
6. To display the access plan graph for one or more explain snapshots, select statements that have explain snapshots, and then select Statement->Show access plan (or use the pop-up menu).