Reduced index size is the most important one, IMHO. Once your indices are larger than than your available memory, write and read performance plummets. This obv

Reduced index size is the most important one, IMHO. Once your indices are larger than than your available memory, write and read performance plummets. This obviously only applies to fairly large tables, but in our case it will be a godsend.