Archives of the TeradataForum
Message Posted: Mon, 25 Nov 2002 @ 13:03:50 GMT
I have a case where I need to build a summary table with data stored at the 'month' level from a table with data stored at the 'day' level. The NUPI of these 2 tables are identical (neither involve the period dimension) and no joins are involved in this aggregation. Teradata performs this aggregation AMP locally then re-distributes the data to all AMPs. This re-distribution step is unnecessary since the 2 tables have the same NUPI. I noticed that the optimizer does this with both physical tables and AJIs.
Shouldn't the optimizer be aware of the fact that the source and destination tables have the same NUPI, and therefore, not re-distribute the data?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|