how UPI gives even distribution

Database

how UPI gives even distribution

i have a question on even distribution in case of  UPI defined. though the values are unique and unique row hash will be generated what would be the guarantee all the row hashes generated wouldnt  be bucketed to same amp. ie if value 5 10 15 20 25 are rowhash value generated and when bucketing takes place in a 5 amp system wouldn't all these go to the same amp ?

1 REPLY
Enthusiast

Re: how UPI gives even distribution

Hi,

Yes, they would, but for small tables it would not cause any issues and for tables with every additional record the probability of that is decreasing. Probability of having 10 rows on the same AMP in TD Express ~ 0.004.