Question

When do you have to avoid using secondary indexes?

a)High cardinality columns
b)Low cardinality columns
c)Numeric columns
d)Text columns

Answer 1

You should avoid using secondary indexes on low cardinality columns because they don't improve performance significantly due to the small number of distinct values.

Step-by-step explanation:

When managing databases, you generally want to avoid using secondary indexes on low cardinality columns. Low cardinality refers to columns with a small number of distinct values. Such columns do not benefit as much from indexing because the index does not significantly improve the performance of queries due to the high likelihood of many records sharing the same value. Secondary indexes are more useful for high cardinality columns where there are many unique values, as these can greatly speed up query times.