Archives of the TeradataForum

Message Posted: Thu, 05 Feb 2004 @ 21:05:18 GMT

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

It's entirely up to you. It doesn't look like a good plan to me. Nested joins only make sense then the number of rows that result are less than the number of blocks in the table they came from. Is the secondary index the nested join uses lumpy (very high rows per value for some values) by any chance?

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