Archives of the TeradataForum

Message Posted: Wed, 18 Oct 2000 @ 11:04:18 GMT

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

Jaz,

You do not mention if you have secondary indexes and/or have collected statistics on the foreign key fields in the fact table? You might try this to give the optimizer information on both sides of the possible joins.

Dave

David W. Roth
Senior Consultant
NCR / Teradata Solutions Group

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