Use an HG index when:
The column will be used in a join predicate
A column has more than 1000 unique values
Foreign key columns require their own, individual HG index. However, if a join index exists, the same column cannot have both an explicitly created HG index and a foreign key constraint.