← Quiz: Query Processing and Optimization: all 10 questions
Quiz: Query Processing and Optimization · Question 3 of 10
A table has 20,000 rows and the column dept has 40 distinct values. About how many rows does the optimizer estimate for…
A table has 20,000 rows and the column dept has 40 distinct values. About how many rows does the optimizer estimate for dept = 'CSE'?
- A.40
- B.800
- C.20,000
- D.500
Answer & explanation
Correct answer: 500
n_r / V(A, r) = 20,000 / 40 = 500, assuming values are evenly spread.
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 →