All challenges
Multiple ChoiceHard 30s

Query plan analysis

Choose the best answer for: query plan analysis
Options
  1. 1EXPLAIN runs the statement and returns its rows
  2. 2EXPLAIN only validates SQL syntax before execution
  3. 3EXPLAIN ANALYZE caches the plan for later reuse
  4. 4EXPLAIN ANALYZE shows actual execution times

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