IBM Books

Viewing explainable statements

Use the Explainable Statements window to view the explainable SQL statements for a selected package.

If an explain snapshot has been taken for a statement, you can use this list to view additional information about the statement (such as its total cost, and a graphical view of its access plan).

Graphic of Overview push button appears here.
Figure rule not displayed.

Before you begin...
Figure rule not displayed.

To view explainable statements details:

  1. Open the Explainable Statements window.

  2. Use the menu items or a statement's pop-up menu to view additional information.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]