Which statement best describes the typical impact of adding indexes in a MIPC database?

• A. Indexes slow reads but slow writes and reduce storage.
• B. Indexes have no impact on write throughput.
• C. Indexes speed reads but slow writes and consume space.
• D. Indexes automatically optimize both reads and writes without trade-offs.

Answer: (C)

Adding indexes creates quick access paths for queries, so reads that can use the index are sped up. But every write must also update the index, which adds overhead and can slow down inserts, updates, and deletes. The index itself also takes up extra storage space. So the typical impact is faster reads, slower writes, and extra storage usage, which is why this option best describes the effect. The other statements either claim reads aren’t sped up, claim there’s no write impact, or claim there are no trade-offs, which isn’t true in practice.