Advantages and Disadvantages of Low

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.

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.

Advantages and Disadvantages of Low_Fast