|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/8/2009 6:02:57 AM
Posts: 8,
Visits: 15
|
|
if 123 is a value of an unique primary index column of a particular table A,it will generate a particular hash value via hashing algorithm...now suppose a second Table B also has 123 in its unique primary index column......this will also generate the same hash value and will be there in the same AMP.in this case how the AMP will know that which row corresponds to which table.
Thanks
Sreehari
sreehari
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/29/2009 2:48:53 AM
Posts: 94,
Visits: 321
|
|
Kind of wizard, but this is the thing which makes Teradata data distribution so optimal...
123 Value will be on same AMP but in different data block(mostly different cylinder also)...
Same AMP thing will make it useful for join purpose i.e when these 2 tables will be joined on this column no data is needed to be redistributed as both are on same AMP.....can be processed locally...
Whenever a new row is inserted a 3 part message is generated Table ID+row hash+PI value...
so a row will definitely go to his companion only, by using Table ID....
For more you can Teradata manuals -Physical Implementation.......
Regards,
Prakhar
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/8/2009 6:02:57 AM
Posts: 8,
Visits: 15
|
|
Hi Thanks for the info.........
my understanding till now was that....all rows in an AMP will be identified by 32bit hash value+32 bit uniqueness vaue.....
sreehari
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 8:47:37 PM
Posts: 283,
Visits: 989
|
|
|
Your understanding is still correct for non-PPI tables. With PPI, the row identifier is effectively extended by 16 bits to include the partition identifier.
|
|
|
|