Archives of the TeradataForum
Message Posted: Wed, 18 Feb 2004 @ 22:37:22 GMT
We often coded this expression with other inner join indexed criteria in V2R4 to trick the machine to avoid a product join and a spool space problem for a small table, large table join. If it is the only join criteria then it will result in a cross join.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|