When applying indexes to tables there are some general rule of thumbs for which type of index is better than the other. For example, fields a ratio of distinct values will typically benefit from a Cluster B-Tree index. However, depending on the use of the table, this may not be the best choice. If a queries on a table typically use aggregate functions, a Cluster index does not perform as well.

If is best to perform tests on the different type of indexes with the most common queries that will be performed on the table and check the results using the DESCRIBE QUERY EXECUTION command to see which type of index will provide the most benefits.