Archives of the TeradataForum

Message Posted: Tue, 10 Aug 2004 @ 23:37:37 GMT

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

Are you joining on the primary index of the large table? That is, do you have connecting terms between the tables that cover every column of the large table's primary index and is the operator in each term = ?

If so, I'm very surprised you're not getting a merge join where the large table is accessed directly. If not, I'm not surprised at all. Perhaps you should show us the query, the DDL and the explain.

Jon

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