EXISTS TABLE: nested iteration
This message indicates a special form of nested iteration. In a regular nested iteration, the entire table or its index is searched for qualifying values.
In an existence test, the query can stop the search as soon as it finds the first matching value.
The types of subqueries that can produce this message are:
Subqueries that are flattened to existence joins
Subqueries that perform existence tests