Viewing the history of previously explained SQL statements

Use the Explained Statements History window to view the history of previously explained SQL statements for a selected database. Each entry is an explained statement that is associated with either:

• A static SQL statement in a package
• A dynamic SQL statement.

Tasks

• Dynamically explaining an SQL statement
• Changing explained statements
• Filtering explained statements
• Finding character strings
• Removing explained statements
• Viewing access plan graphs
• Viewing text (or optimized text) for an SQL statement

Information on this view

• Reading the contents of the Explained Statements History window

Related information

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