← Quiz: Query Processing and Optimization: all 10 questions
Quiz: Query Processing and Optimization · Question 6 of 10
In SQLite's EXPLAIN QUERY PLAN, what does SCAN students mean?
In SQLite's EXPLAIN QUERY PLAN, what does SCAN students mean?
- A.An index on students is used
- B.Every row of students is read (full table scan)
- C.The table is sorted
- D.The query failed
Answer & explanation
Correct answer: Every row of students is read (full table scan)
A SEARCH line with USING INDEX would mean an index lookup.
Can you get the rest right without peeking?
Take the timed Quiz: Query Processing and Optimization quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →