Index Overhead

Difficulty: Beginner

Question

Why shouldn't you index every single column in a table?

Answer

Every index slows down WRITE operations (Insert/Update/Delete) because the database must update the index structure every time the data changes.

Concepts covered

Performance, Write Speed