All challenges
Multiple ChoiceIntermediate 30s

N+1 Queries

The N+1 query problem occurs when:
Options
  1. 1A single query returns N rows and needs no further queries
  2. 2One query fetches N rows, then N more queries fetch each row's relations
  3. 3A table has N indexes that slow down every insert and update
  4. 4A join fetches all of the related rows for every record in one round trip

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle