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.