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 Blue cross icon 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.

Select icon
Final Select

Unknown icon
Table

Table scan icon
Table Scan

Table probe icon
Table Probe

Radix index icon
Index

Index key selection icon
Index Scan

Index key positioning icon
Index Probe

Encoded vector index icon
Encoded Vector Index

Encoded vector index scan icon
Encoded Vector Index Scan

Encoded vector index probe icon
Encoded Vector Index Probe

Temporary hash table icon
Temporary Hash Table

Hash table scan icon
Hash Table Scan

Hash table probe icon
Hash Table Probe

Temporary distinct hash table icon
Temporary Distinct Hash Table

Distinct hash table scan icon
Distinct Hash Table Scan

Distinct hash table probe icon
Distinct Hash Table Probe

Temporary sorted list icon
Temporary Sorted List

Temporary distinct sorted list icon
Temporary Distinct Sorted List

Sorted list scan icon
Sorted List Scan

Sorted list probe icon
Sorted List Probe

Temporary list icon
Temporary List

List scan icon
List Scan

Temporary row number list icon
Temporary Row Number List

Row number list scan icon
Row Number List Scan

Row number list probe icon
Row Number List Probe

Temporary row number bitmap icon
Temporary Row Number Bitmap

Bitmap scan icon
Bitmap Scan

Bitmap probe icon
Bitmap Probe

Temporary index icon
Temporary Index

Temporary index scan icon
Index Scan (Temporary)

Temporary index probe icon
Index Probe (Temporary)

Temporary correlated hash table icon
Temporary Correlated Hash Table

Correlated hash table scan icon
Correlated Hash Table Scan

Correlated hash table probe icon
Correlated Hash Table Probe

Temporary correlated list icon
Temporary Correlated List

Correlated list scan icon
Correlated List Scan

Temporary buffer icon
Temporary Buffer

Buffer scan icon
Buffer Scan

Table random pre-fetch icon
Table Random Pre-Fetch

Table clustered pre-fetch icon
Table Clustered Pre-Fetch

Index random pre-fetch icon
Index Random Pre-Fetch

Aggregation icon
Aggregation

Multiple aggregation icon
Multiple Aggregation

Nested loop join icon
Nested Loop Join

Logic icon
Logic

Bitmap merge icon
Bitmap Merge

Fetch N rows icon
Fetch N Rows

Lock row for update icon
Lock Row for Update

UNION merge icon
UNION Merge

Table scan, parallel icon
Table Scan, Parallel

Skip sequential table scan icon
Skip Sequential Table Scan

Skip sequential table scan, parallel icon
Skip Sequential Table Scan, Parallel

Derived column selection icon
Derived Column Selection

Derived column selection, parallel icon
Derived Column Selection, Parallel

Index scan - key positioning, parallel icon
Index Scan - Key Positioning, Parallel

Index scan - key selection, parallel icon
Index Scan - Key Selection, Parallel

Encoded vector index, parallel icon
Encoded Vector Index, Parallel

Sort sequence icon
Sort Sequence

Distinct icon
DISTINCT

Subquery merge icon
Subquery Merge

Hash join icon
Hash Join

Incomplete information icon
Incomplete Information

User-defined table function icon
User-defined table function

Select icon
Select

Key icon
Key

Data icon
Data

Building key icon
Building key

Pasted field icon
Pasted field

Derivation logic icon
Derivation Logic

Variable reference icon
Variable reference

Column icon
Column

Literal icon
Literal

Aggregate icon
Aggregate

Values list icon
Values list

Special register icon
Special Register

Union switch icon
Union Switch

Queue icon
Queue

Enqueue icon
Enqueue

Dequeue icon
Dequeue

RI reduction union icon
RI reduction union

RI reduction union icon
RI reduction union

Rank icon
Rank

Cache icon
Cache

Cache probe icon
Cache probe

Complicated expression icon
Complicated expression

Generic object icon
Generic object

At most one icon
At Most One

At least one icon
At Least One

If none one icon
If None One

EVI symbol table scan icon
EVI Symbol Table Scan

EVI symbol table probe icon
EVI Symbol Table Probe

Operators