A comparison of HG with LF and HNG indexes.
HNG
The determining factor is whether the column is a join column,
and/or whether GROUP BY may be processed
on the column. If either of these is true, use High_Group,
either alone or in combination with High_Non_Group. Otherwise,
use High_Non_Group to save disk space.