IBM Books

Explain snapshot

This box contains the selection criteria for the Explain snapshot column in Explainable Statements and Explained Statements History windows.

Yes
Display only SQL statements that have explain snapshots (that is, statements whose entry in the Explain Snapshot column is "Yes").

No
Display only SQL statements that do not have explain snapshots (that is, statements whose entry in the Explain Snapshot column is "No").

Both
Display all SQL statements, whether or not they have explain snapshots.

To change the value, use one of these methods:

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

[ DB2 List of Books | Search the DB2 Books ]