Archives of the TeradataForum

Message Posted: Sun, 17 Jun 2001 @ 15:07:31 GMT

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

Hi Rudel,

Although the explain identifies the number of rows, the optimiser decides to copy a table across the nodes before this is known. That decision is based on collected statistics, the index and whether the join condition in your view matches the index precisely.

Make sure you have collected statistics on the smaller tables after indexing, or creating secondary indexes which exactly match the join condition of your view.

Ken Hansen

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