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>>