Filter Explained Statements -- Fields and controls

" " Explain table schema
" " Package name
" " Package creator
" " Total cost
" " Query tag
" " SQL text
" " Remarks
" " Explained since date
" " Explain snapshot
" " Latest bind
" " Dynamic explain
" " OK
" " Clear
" " Cancel


" " Explain table schema

Type the explain table schema to be used to qualify the explain tables. The schema:

If you do not specify the explain table schema, then the connected user ID's explain tables are used.

" " Package name

Type the name of the package that either:

The name must be 1 to 8 alphanumeric characters.

" " Package creator

Type the user ID of the user who created the package.

The user ID must be 1 to 8 alphanumeric characters.

" " Total cost

Type a number that will be used to filter on the total cost field. Explained statements with the total cost greater than or equal to the specified value will be displayed.

" " Query tag

Type a short comment that will be used to filter on the query tag field.

" " SQL text

Type a string that will be used to filter on the SQL text field.

" " Remarks

Type a string that will be used to filter on the remarks field.

" " Explained since date

Type a date that will be used to filter on the explain date field. Explained statements created since the specified date will be displayed.

" " Explain snapshot

This box contains the selection criteria for the Explain snapshot column in Explainable Statements and Explained Statements History windows.

Yes
Display only SQL statements that have explain snapshots (that is, statements whose entry in the Explain Snapshot column is "Yes").

No
Display only SQL statements that do not have explain snapshots (that is, statements whose entry in the Explain Snapshot column is "No").

Both
Display all SQL statements, whether or not they have explain snapshots.

To change the value, use one of these methods:

" " Latest bind

This box contains the selection criteria for the Latest bind column in Explained Statements History window.

Yes
Display only SQL statements that are contained in a package (that is, statements whose entry in the Latest bind column is "Yes").

No
Display only SQL statements that are not contained in a package (that is, statements whose entry in the Latest bind column is "No").

Both
Display all SQL statements, whether or not they are contained in a package.

To change the value, use one of these methods:

" " Dynamic explain

This box contains the selection criteria for the Dynamic explain column in Explained Statements History window.

Yes
Display only dynamic SQL statements (that is, statements whose entry in the Dynamic explain column is "Yes").

No
Display only static SQL statements static SQL statements (that is, statements whose entry in the Dynamic explain column is "No").

Both
Display both dynamic and static SQL statements.

To change the value, use one of these methods: