Hi all,
Please close this bug ticket I created since it is not a problem
anymore. I don't know if it was because I upgraded from 11.2 to 11.4 or
I wasn't reading the explain output correctly. It does appear to work
even on different variations of unnordered joins where the key phrase,
"never executed", does show up on the explain output for the partitions
that do not contain the partition key values as implied by the join.
Thanks in advance.
Michael Vitale