For the TEMP operator, the following input
arguments are shown:
- Materialization
- The level of materialization applied to temporary tables. Possible
values are:
- Full
- All rows are put into a temporary table before any rows are read from
it.
- Slow
- Some rows are put into a temporary table and are read from it before all
rows have been inserted into it.
- Common subexpression
- A flag that is true if the temporary table contains a common subexpression
(that is, an access plan that is read by more than one SCAN).
- Columns retrieved
- The set of columns that will be stored in the temporary table.
- Intra-partition shared
- A flag that is set to true if the creation of the temporary table is
shared between the subagents. (This item is displayed only for intra-partition parallelism or full
parallelism (intra-partition and inter-partition)).
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]