Question

When to avoid secondary indexes?

Answer 1

Try not using secondary indexes on columns contain a high count of unique values and that will produce few results.