For the NLJOIN operator, the following input
arguments are shown:
- Early out
- A flag that is true if only one inner row matching outer row is needed
("early out").
- Join predicates
- The join predicates upon which the join is
performed.
- Max pages for IXSCAN
- The maximum number of leaf pages of the index for the inner join, expected
to be read from disk for all rows of the outer join. The closer this
number is to zero, the more the prefetch quantity will be reduced.
- Max pages for FETCH
- The maximum number of pages of the table for the inner join, expected to
be read from disk for all rows of the outer join. The closer this
number is to zero, the more the prefetch quantity will be reduced.
- Outer join type
- A flag indicating which type of outer join this NLJOIN operator is
performing:
| Note: | Maximum pages for FETCH or IXSCAN on the inner join represents the number of
pages read per outer row of a join.
|
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]