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).

Authorities and privileges

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.

Information on this view

• Reading the contents of the Explainable Statements window

Related information

• Creating an access plan graph
• Viewing explainable statements for a package
• Using Visual Explain windows and notebook