Array unnest temporary table scan
During an array unnest temporary table scan operation, the temporary table is processed one row at a time.
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 |
|
Database Monitor and Plan Cache record indicating use | QQRID 3000 where QVQTBL = '*UNNEST' |
SMP parallel enabled | Yes |
Also referred to as | |
Visual Explain icon | ![]() |