Advantages and disadvantages of Low_Fast

The following table lists advantages and disadvantages of Low_Fast indexes.

**Table 6-6: LF advantages/disadvantages**
Advantages	Disadvantages
This index is fast, especially for single table SUM, AVG, COUNT, COUNT DISTINCT, MIN, and MAX operations.	Can only be used for a maximum of 10,000 unique values. Cannot use this index if data in your columns is BIT, VARBINARY > 255 bytes, CHAR > 255 bytes, or VARCHAR > 255 bytes.