Filter Explainable Statements -- Fields and controls

" " SQL text
" " Total cost
" " Explain snapshot
" " OK
" " Clear
" " Cancel


" " SQL text

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

" " Total cost

Type a number that will be used to filter on the total cost field. Explainable statements with the total cost greater than or equal to the specified value 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: