Single-table join indexes are very useful for resolving joins on large tables without having to redistribute the joined rows across the AMPs.
Single-table join indexes facilitate joins by hashing a frequently joined subset of base table columns to the same AMP as the table rows to which they are frequently joined. This enhanced geography eliminates BYNET traffic as well as often providing a smaller sized row to be read and joined.