Write Amplification in Indexes

Problem

A developer added 15 indexes to a single table to speed up all possible search queries. Now, API insert endpoints are timing out. Explain the trade-off. Write a query that outputs explanation with the value: "Every index on a table increases write amplification, slowing down INSERT, UPDATE, and DELETE operations as indexes must be updated."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution