Node name: XSCAN
Represents: This node processes node references passed by a nested-loop join node (NLJOIN). It is not represented with a direct input in the access plan.
XQUERY for $i in db2-fn:xmlcolumn("MOVIES.XMLCOL")//actor return $i
The access plan for this statement as provided by the db2exfmt utility shows an XSCAN node processing document node references retrieved by a table scan on the table TELIAZ.MOVIES. The XSCAN node in this case returns actor node references found within the TELIAZ.MOVIES.XMLCOL collection.
Rows
RETURN
( 1)
Cost
I/O
|
180
NLJOIN
( 2)
10137.9
1261
/-+\
180 1
TBSCAN XSCAN
( 3) ( 4)
21.931 56.2
1 7
|
180
TABLE: TELIAZ
MOVIES