Indexes should be designed based on the database's actual usage
Correct:
Indexes should be designed based on the database's actual usage
Explanation:
Answer C is correct. Writing good indexes often means analyzing the actual usage of a database and determining its weak points. It’s also a good way of optimizing scripts that perform redundant queries needlessly!