Array unnest temporary table scan

During an array unnest temporary table scan operation, the temporary table is processed one row at a time.

Table 1. Array unnest temporary table scan operation
Data access method Array unnest temporary table scan
Description Sequentially scan and process all the rows of data in the unnest temporary table.
Advantages The array unnest temporary table and temporary table scan can be used to simplify the logic flow of the optimizer for processing arrays.
Likely to be used When an UNNEST clause is specified in the from-clause of an SQL fullselect.
Example SQL statement
CREATE PROCEDURE processCustomers() 
BEGIN 
DECLARE ids INTARRAY; 
DECLARE names STRINGARRAY; 
set ids = ARRAY[5,6,7]; 
set names = ARRAY['Ann', 'Bob', 'Sue']; 
INSERT INTO customerTable(id, name, order) 
(SELECT Customers.id, Customers.name, Customers.order 
FROM UNNEST(ids, names) WITH ORDINALITY 
AS Customers(id, name, order) ); 
END  
CALL processCustomers()
Database Monitor and Plan Cache record indicating use QQRID 3000 where QVQTBL = '*UNNEST'
SMP parallel enabled Yes
Also referred to as  
Visual Explain icon
Visual Explain - array unnest