Visual Explain Icons
The following icons can be displayed in the left pane of the Visual Explain window. These icons represent the operations used in the implementation
of your query. You can use these icons, along with the attributes and values
in the right pane, to help you better understand the implementation decisions made during execution of your
statement and to help determine where the highest costs
of your queries are taking place.
If an icon has a blue cross
next ot it, you can right click the icon and
select Expand or Expand to window to view a subgraph of the query operation.
You can also view help for an individual icon by right-clicking on an icon and selecting Help.
Final Select
Table
Table Scan
Table Probe
Index
Index Scan
Index Probe
Encoded Vector Index
Encoded Vector Index Scan
Encoded Vector Index Probe
Temporary Hash Table
Hash Table Scan
Hash Table Probe
Temporary Distinct Hash Table
Distinct Hash Table Scan
Distinct Hash Table Probe
Temporary Sorted List
Temporary Distinct Sorted List
Sorted List Scan
Sorted List Probe
Temporary List
List Scan
Temporary Row Number List
Row Number List Scan
Row Number List Probe
Temporary Row Number Bitmap
Bitmap Scan
Bitmap Probe
Temporary Index
Index Scan (Temporary)
Index Probe (Temporary)
Temporary Correlated Hash Table
Correlated Hash Table Scan
Correlated Hash Table Probe
Temporary Correlated List
Correlated List Scan
Temporary Buffer
Buffer Scan
Table Random Pre-Fetch
Table Clustered Pre-Fetch
Index Random Pre-Fetch
Aggregation
Multiple Aggregation
Nested Loop Join
Logic
Bitmap Merge
Fetch N Rows
Lock Row for Update
UNION Merge
Table Scan, Parallel
Skip Sequential Table Scan
Skip Sequential Table Scan, Parallel
Derived Column Selection
Derived Column Selection, Parallel
Index Scan - Key Positioning, Parallel
Index Scan - Key Selection, Parallel
Encoded Vector Index, Parallel
Sort Sequence
DISTINCT
Subquery Merge
Hash Join
Incomplete Information
User-defined table function
Select
Key
Data
Building key
Pasted field
Derivation Logic
Variable reference
Column
Literal
Aggregate
Values list
Special Register
Union Switch
Queue
Enqueue
Dequeue
RI reduction union
RI reduction union
Rank
Cache
Cache probe
Complicated expression
Generic object
At Most One
At Least One
If None One
EVI Symbol Table Scan
EVI Symbol Table Probe
Operators