Need Information on Autonumberhash128

[nagarajuabhi]

Hi team,

I have created a composite key (%key) using autonumberhash128 in two tables using same fields.  Is it preferable to use this %key for joining two tables. like below

eg:

tab1:

load *,

Autonumberhash128(column A & column b) as %Key

from table1

LEFT JOIN(tab1)

tab2:

load *,

Autonumberhash128(column A & column b) as %Key

from table2

[rwunderlich]

If you join the tables, there is no need to create a composite key for the join.  Instead join using column A and Column B.

-Rob

[shiveshsingh]

If you need to join tables in two columns, A and B.. it depends on the amount of data i guess, Autonumberhash128 can optimise your application.