Archives of the TeradataForum

Message Posted: Tue, 27 Sep 2005 @ 09:34:57 GMT

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

Thanks a lot Jonathan !!! This would really help.

We have kept PDM in 3NF form only. And we are using SGK for tables like Party, Address and Product but tables like Aggrement & Event are uniquely identified via concatenation of source fields. Now, if we create UPI on PK columns, distribution will be good but did I would like to know if you found any performance impact while handling the tables like Account-Party, Account-Event because of UPI created on PK columns.

Thanks

Rishi

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