Archives of the TeradataForum

Message Posted: Wed, 26 May 2004 @ 19:47:30 GMT

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

Hello Anomy

Thank you for answering.

You wrote "Presumably the PI of the aggregate table would be the same as your GROUP BY columns."

This is not case. But the PI of the aggregate table is "contained" in the group by columns, ie:

     PI of base-table = (Column1,Column2)
     PI og aggregate table = (Column1,Column2)
     Group by columns = (Column1,Column2,some other columns)

Ole Dunweber

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