Low_Fast indexes have advantages and disadvantages.
Advantages |
Disadvantages |
---|---|
This index is fast, especially for single table SUM, AVG, COUNT, COUNT DISTINCT, MIN, and MAX operations. |
Use this index type for a maximum of 10,000 unique values. You cannot use this index type if data in your columns is BIT, VARBINARY > 255 bytes, CHAR > 255 bytes, or VARCHAR > 255 bytes. |