Archives of the TeradataForum

Message Posted: Mon, 25 Nov 2002 @ 13:03:50 GMT

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

All,

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?

Thanks,

Claybourne Barrineau

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