A comparison of the HNG index to similar indexes.
HNG needs less disk space than HG but cannot perform GROUP BY efficiently.
In choosing between LF and HNG, the determining factor is the number of unique values. Use HNG when the number of unique values is greater than 1000.