Archives of the TeradataForum

Message Posted: Mon, 13 Nov 2006 @ 16:10:43 GMT

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

Not sure what you mean by "never used" but if you agree that NUSI are used in nested joins then USI can be used in pretty much the same way.

The "Database Design" manual lists many examples of nested joins when USI are defined on the left and / or right tables. Although the micro- level internal mechanisms might differ between NUSI and USI, from user's perspective everything is pretty much the same as far as the explain plan is concerned, and that is the level the original question was formulated on.

The examples are discussed in the context of the "few-AMP joins", by the way, which probably did not mature at the time when Glenn wrote the paper. Possibilities in this area depend on the database release.

Regards,

Victor

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