Archives of the TeradataForum

Message Posted: Sat, 06 Oct 2001 @ 22:57:16 GMT

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

Any time your are doing a join, remember to collect statistics on any columns that are used in the join.

This will provide better information on which table to distribute. Run your explain before and after collecting statistics.

Wayne N. Moran

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