AhaBulbStuff Everyone Should Know
AhaBulb: Stuff Everyone Should Know · ahabulb.com/tech-index-tradeoff

Database indexes speed up searches. What is their cost?

Start playing free

  1. They make all queries slower
  2. They add overhead to data changes
  3. They delete old rows

🔒 The answer is for AhaBulb members. Members see the answer, why it's right and the official sources for every card of Stuff Every Technology Expert Should Know, plus timed practice exams.

The first 50 cards of every test are free to play.

Play the free cards See membership

Like this card?
Play the game

References

  1. PostgreSQL Documentation: Indexes www.postgresql.org/docs/current/indexes.html Checked 2026-10-10.

Think this answer is wrong? Tap "Challenge this answer" on the card in the game and tell us why.

Test yourself in the game

Tech & GadgetsIn a relational database, what two rules does a primary key enforce?Tech & GadgetsSQL is called a declarative language. What does that mean?Tech & GadgetsA bank transfer takes money from Alice and gives it to Bob. Why wrap it in a transaction?

That's stuff everyone should know.