Archives of the TeradataForum
Message Posted: Wed, 26 May 2004 @ 19:47:30 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|