Used to dynamically explain an SQL statement.
Used 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).
Used 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; or a dynamic SQL statement.
Used to change the query number, query tag, or
remarks field of explained statements shown in the Explained Statements
History window.
Used to filter the information in the Explainable
Statements window.
Used to filter the information in the Explained
Statements History window.
Used to view the text for an SQL statement, or use
the Optimized SQL Text window to view the text for an SQL statement that was
rewritten by the optimizer.
Used to view the text for an explained SQL statement
that was rewritten by the optimizer.
Used to find a specific character string in the text
of the window you are using.
Used to view a graphical representation of the access plan of an explained SQL statement.
The nodes in the graph represent tables and
indexes and each operation on them. The links between the nodes
represent the flow of data.
Used to change settings that affect the content and
appearance of the access plan graph.
Database Partitions -- OPERATOR
Used to view the database
partitions that have been accessed thus far for an operator that is selected in the Access Plan Graph
window.
Used to view the list of built-in functions and
user-defined functions that are associated with the SQL statement whose
access plan is shown in the graph.
Used to view the list of indexes that are defined on
the table that is shown in the Table Statistics window.
Used to view details for an operator that is selected in the Access Plan Graph
window.
Used to view the configuration parameters and bind
options that affect the optimization process. Current values are
shown, as well as values from the time of the explain.
Used to view a list of the columns that are associated with the SQL statement whose access plan is shown in the graph.
These columns belong to the table that is shown in the Table Statistics
window.
Used to view the list of table spaces that are
associated with the SQL statement whose access plan is shown in the
graph.
Used to view the column distribution values for the
column that is shown in the Referenced Column Statistics window.
Used to view statistics for a built-in or user
defined function that is associated with the explained SQL statement.
Used to view statistics for an index node selected
in the Access Plan Graph or an index entry selected in the Indexes
window.
Used to view the estimated number of page fetches
for each hypothetical number of buffer pages as an ordered set of
pairs. The numbers model the number of I/Os required to read the data
pages into buffer pools of various sizes.
Used to view statistics for a column that is
referenced in a selected table.
Used to view statistics for a table function node selected in the access plan graph.
Used to view statistics for the table node selected in the Access Plan Graph.
Used to view statistics for a table space that is associated with an explained SQL
statement.
Used to specify printer and print options.