Which of the following statements is not true about indexes?
A)They should be added to every field.
B)They should be added to fields which are searched or sorted often.
C)They improve performance.
D)They are commonly suggested by the Performance Analyzer tool.

Question

Quizplus · Accepted Answer

Indexes should not be added to every field, as this can actually decrease performance and use unnecessary resources. Indexes should only be added to fields which are frequently searched or sorted.

Which of the Following Statements Is Not True About Indexes