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