Kbase P47718: What does message "no join operator exists" in sql.trc mean?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
What does message "no join operator exists" in sql.trc mean?
FIX:
<no join operator exists>
Means that there is no subquery join operator driving the join.
For example,
select custnum from customer
where custnum > (select custnum from SomeOtherTable where ....);
Here the "join operator" would be ">".
>| | | ,
>| | | | (PEXPR9) = (PEXPR30) and [join expr]
>| | | | (PEXPR10) = (PEXPR29)
>
These are predicates which apply to both tables in the join, and the
predicates are not being
used to drive an index search.
After each pair of joining records are found, these predicates are
evaluated on those records.
If they are true, the records do join. If not, the pair does not join.
The form and control of the sql.trc file is totally unsupported and subject to change without notice.