SQL Quiz
10 questions · no time limit
0:00
PERFORMANCE AND OPTIMIZATION
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
An
EXPLAIN ANALYZE plan for a join shows a nested-loop operation. Its outer input produces 30,000 rows. The inner operation performs a full scan of devices and reports approximately 30,000 loops while applying devices.serial_no = events.device_serial. No index exists on devices.serial_no.Which change most directly targets the repeated work visible in this plan?
YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end