Archives of the TeradataForum
Message Posted: Fri, 08 Feb 2002 @ 20:10:19 GMT
I do not have a system available to attempt this, but you might try it.
The inner join syntax can be written with either a WHERE clause to add residual condition(s) or a compound ON (as shown in the two examples below).
Although the answer set is the same for both, it would be interesting to know for sure if this changes the join plan to use the index in a nested join instead of redistribution for a merge join.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|