Index
A
B
C
D
E
F
G
H
I
J
M
N
O
P
Q
R
S
T
U
V
W
X
A
access plan diagrams
Canvas
description
descriptions of nodes
example
nodes
overviews
printing
saving
searching
setting preferences
special registers
viewing
access plan graph
nodes
access plans
diagramming
Auxiliary nodes
B
buffer table node
C
CMPEXP node
definition
common table expression node
constructs
multiple query blocks
D
data source
Data source nodes
DELETE node
definition
DOCID node
E
EISCAN node
definition
F
FETCH node
definition
FILTER node
definition
G
GENROW node
definition
GRPBY node
definition
H
HSJOIN node
definition
I
IN-MEMORYTABLE node
index node
INSERT node
definition
IXAND node
definition
IXSCAN node
definition
J
Join Nodes
M
materialized query table node
MSJOIN node
definition
multiple query blocks
N
NLJOIN node
definition
nodes
buffer table node
CMPEXP
common table expression node
DELETE
description
(1)
,
(2)
DOCID node
EISCAN
FETCH
FILTER
GENROW
GRPBY
HSJOIN
IN-MEMORYTABLE node
index node
INSERT
IXAND
IXSCAN
materialized query table node
MSJOIN
NLJOIN
PIPE
pipe node
RETURN
RIDSCN
RPD
SHIP
SORT
sparse index node
star join dimension work file node
table function node
table node
TBSCAN
TEMP
TQ
UNION
UNIQUE
UPDATE
Virtual index node
Virtual table node
work file node
XANDOR
XISCAN
XML INDEX node
XSCAN
Nodes
auxiliary
join
operator
setting preferences
O
Operator nodes
P
pipe node
PIPE node
definition
Q
QUERY node
definition
R
RIDSCN node
definition
RPD node
definition
S
SHIP node
definition
SORT node
definition
sparse index node
special registers
description
SQL statements
diagramming access plans
star join dimension work file node
T
table function node
table node
TBSCAN node
definition
TEMP node
definition
TQ node
definition
U
UNION node
definition
UNIQUE node
definition
UPDATE node
definition
V
Virtual index node
Virtual table node
Visual Explain
access plan diagrams
appearance
constructs
diagramming access plans
explain data
nodes
appearance
purpose
running traces
setting preferences
special registers
(1)
,
(2)
,
(3)
terminator
working directory
W
work file node
X
XANDOR node
definition
XISCAN node
definition
XML INDEX node
XPATH statements
diagramming access plans
XSCAN node
definition
Feedback