Archives of the TeradataForum
Message Posted: Wed, 14 Dec 2011 @ 19:04:21 GMT
What is the advantage of defining PI on more than 2 columns?? I understand, for even data distribution the PI should be unique and should be defined only on single column.
But I see many tables in my environment, with PI defined on 4-5 columns and more.
Can you please share your thoughts on the advantages and disadvantages on this and the data distribution on amps and accessibility of data in such cases.
Sravan Kumar Bodla
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|