{CodeRoyale}
All challenges
Multiple ChoiceIntermediate 30s

Database query optimization

Choose the best answer for: fast queries
Options
  1. 1No optimization at all, running the same query the page always ran
  2. 2No indexes, scanning every row and fetching all columns each time
  3. 3Add indexes; avoid SELECT *; use EXPLAIN; limit results
  4. 4Select all columns and rows, then filter in application code
fullstackintermediate

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