Question

When do you have to avoid using secondary indexes

On columns containing high count of unique values

Use secondary index on as many columns

On columns containing less count of unique values

can use it on any columns without effecting performance

Answer 1

On columns containing high count of unique values