{CodeRoyale}
All challenges
Multiple ChoiceIntermediate 30s

Query optimization

Choose the best answer for: EXPLAIN ANALYZE
Options
  1. 1Runs the query faster by rewriting it into indexed form
  2. 2Shows query execution plan and actual timings
  3. 3Deletes the query from the plan cache to free memory
  4. 4Performs no analysis and returns raw rows to the client
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