Choosing from a list of previously explained SQL statements

To display an access plan graph by choosing from a list of previously explained 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. Then, open the Explained Statements History by doing one of the following:
   • Select Show explained statements history from the pop-up menu.
   • Click on the Packages icon (under the Application Objects folder). Any existing Package objects are displayed on the right side of the window (the contents pane). Do one of the following:
     • Click mouse button 2 on the package that you want and select Show explained statements history from the pop-up menu.
     • Click mouse button 2 on the package that you want and select Show explainable statements from the pop-up menu. From the Explainable Statements window, select Statement->Show explained statements history.
2. To display other explained SQL statements that exist for the database but are not shown in the window (for example, explain snapshots that were created or imported by another user ID), select View->Filter and change the filtering criteria.

   If you are using the sample snapshots that were created by another user ID, enter that user ID in the Explain table schema field.

3. To display the access plan graph for a single explain snapshot, double-click on a statement that has one (that is, one whose entry in the Explain Snapshot column is "Yes").
4. 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).