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 that statement (such as its total cost and a graphical view of its access plan).

Tasks

• Dynamically explaining an SQL statement
• Filtering explainable statements
• Viewing an access plan graph
• Viewing explained statements
• Viewing text for an SQL statement

Information on this view

• Reading the contents of the Explainable Statements window

Related information

• Introduction to Visual Explain
• Sorting explainable statements
• Customizing explainable statements
• Finding character strings

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

[ DB2 List of Books | Search the DB2 Books ]