The columns in the window provide the following
information about SQL statements that have been explained.
- Package name
- The name of the package that either:
- Contains the SQL statement (in the case of static SQL)
- Issued the SQL statement (in the case of dynamic SQL).
- Package creator
- The user ID of the user who created the package.
- Explain snapshot
- States whether an explain snapshot has been
taken for the SQL statement. (If it has not, you cannot view an access
plan graph for the statement.)
- Latest bind
- If the statement is contained in a package, this field indicates whether
or not the statement is associated with the latest bound package.
- Dynamic explain
- States whether the explained SQL statement was dynamic. (If it was not, it was a static SQL statement in a package.)
- Explain date
- The date when the statement had an explain operation performed on
it.
- Explain time
- The time when the statement had an explain operation performed on
it.
- Total cost
- The estimated total cost (in timerons) of the
statement.
- Statement number
- The line number of the SQL statement in the source module of the
application program.
- Section number
- The number of the section within the package that is associated with the
SQL statement.
- Query number
- The query number that is associated with the statement.
- Query tag
- The query tag that is associated with the statement.
- SQL text
- The first 100 characters of the original SQL statement. (Use the
scroll bar at the bottom of the window to scroll through it.)
To view the complete SQL statement, select Statement->Show SQL
text.
- Remarks
- Any remarks associated with the statement. (For example, for a
static SQL statement, the remark associated with the package containing the
statement.)