Viewing explainable statements for a package

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 a graphical representation of an access plan
• Viewing the history of previously explained SQL statements
• Viewing text (or optimized text) for an SQL statement

Information on this view

• Reading the contents of the Explainable Statements window

Related information

• Creating an access plan graph
• Sorting explainable statements
• Customizing explainable statements
• Finding character strings
• Using Visual Explain windows and notebook