Thank dnoeth for your explanation. But Teradata says that UPI provide even dsitribution of rows. I agree with your explanation but there should be a way how rows will be distribute among AMPs with UPI. So if I insert 100 rows into 10AMPs...what are the factors that affect even distribution and how to find number of rows present in each AMP along with AMP number?
Thanks in advance.
You shouldn't care about small tables, a UPI approaches an even distribution when the number of rows increases.
And the query to find the number of rows/AMP is shown in the 1st post.