Archives of the TeradataForum

Message Posted: Tue, 14 Jan 2003 @ 23:44:17 GMT

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

Adding an additional constrain to the Store table will not avoid the Product join in this case. Even if you retrieve only one record from Store, this record will be duplicated in all the AMPS and then the Product join will occur.

Jose

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