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.