Archives of the TeradataForum

Message Posted: Wed, 18 Jun 2014 @ 21:13:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

There's no way to remove this. Any ORed join condition will always be a product join, because the optimizer needs to know which AMP processes the join. The PI columns must be hashed to determine the AMP and only ANDed conditions can be hashed.

But this join looks quite strange, it's not a common equi-join, what is this user trying to do?

Can you show the full SQL?

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>