Discussion:
clarification about output statistic
(too old to reply)
Taras
2011-03-06 18:07:48 UTC
Permalink
Hello,

I just want to clarify what needs to be printed by output statistic. In
"the total number of output tuples obtained by probing with inner
inputs" what is meant by "output tuples obtained"? Is it the number of
output tuples obtained from the hash table by probing with inner tuples,
or the number of tuples returned in the final result of the hash-join
obtained by probing with inner tuple? (It seems like these numbers might
be different)

In other words, do we have to count the tuples right after they are
found in the hash table, or just before they are returned from the
HashJoin operator?

Thanks,
Taras
Ken Salem
2011-03-06 21:24:28 UTC
Permalink
Output tuples are tuples returned by the join.
-KMS
Post by Taras
Hello,
I just want to clarify what needs to be printed by output statistic. In "the total number of output tuples obtained by probing with inner inputs" what
is meant by "output tuples obtained"? Is it the number of output tuples obtained from the hash table by probing with inner tuples, or the number of
tuples returned in the final result of the hash-join obtained by probing with inner tuple? (It seems like these numbers might be different)
In other words, do we have to count the tuples right after they are found in the hash table, or just before they are returned from the HashJoin operator?
Thanks,
Taras
Loading...