Archives of the TeradataForum
Message Posted: Tue, 14 Jan 2003 @ 23:44:17 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|