Join Index

Database

Join Index

Hi,

Just wanted to confirm whether the rows of join index are distributed across the amps based on the hash value of primary index or are they amp local like NUSI.

Regards,

AB

2 REPLIES
Enthusiast

Re: Join Index

Hi padthai_noodles,

A JI table is hash-distributed, with possibly a different distribution of rows to the AMPs and row ordering on the AMPs from the base table rows

Re: Join Index

Hi Kaushik,

Thanks for the reply. If its hash distributed, how come it is different distribution to the amps?