← Quiz: Query Processing and Optimization: all 10 questions
Quiz: Query Processing and Optimization · Question 10 of 10
Statistics in the catalog are badly out of date after a huge data import. What is the likely effect?
Statistics in the catalog are badly out of date after a huge data import. What is the likely effect?
- A.Queries return wrong results
- B.Indexes are deleted
- C.The optimizer may estimate sizes wrongly and choose a slow plan
- D.Nothing — statistics are not used
Answer & explanation
Correct answer: The optimizer may estimate sizes wrongly and choose a slow plan
Plans are chosen from estimates; refresh them with ANALYZE.
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 →