The following table shows some of the miscellaneous operations you may encounter while using the Explain SQL window.
| Operation | Option | Description |
|---|---|---|
|
FOR UPDATE |
The rows returned are locked as a result of the FOR UPDATE clause. | |
|
FILTER |
Rows from a result set that do not match a selection criteria are eliminated. | |
|
REMOTE |
An external database is accessed through a database link. | |
|
SEQUENCE |
An Oracle sequence generator is accessed to obtain a unique sequence number. | |
|
SORT |
ORDER BY |
A result set is sorted in order to satisfy an ORDER BY clause. |
