Question

Which of the following is condition where indexes be avoided?

A) Indexes should not be used on small tables.
B) Tables that have frequent, large batch updates or insert operations.
C) Columns that are frequently manipulated should not be indexed.
D) All of the above.

Answer 1

The condition where indexes should be avoided is when any of the given options are true.

Step-by-step explanation:

The correct option for the condition where indexes should be avoided is D) All of the above.

Indexes should not be used on small tables because the cost of maintaining the index may outweigh the benefit. Tables that have frequent, large batch updates or insert operations should also avoid indexes because updating the indexes can be time-consuming.

Additionally, columns that are frequently manipulated, such as those involved in calculations or string manipulations, should not be indexed to avoid the overhead of maintaining the index.