← Quiz: Query Processing and Optimization: all 10 questions
Quiz: Query Processing and Optimization · Question 2 of 10
Why does "push selections down" usually make a query faster?
Why does "push selections down" usually make a query faster?
- A.It removes the need for indexes
- B.It sorts the rows
- C.Filtering early makes the inputs to later operations, such as joins, much smaller
- D.It changes the result to fewer columns
Answer & explanation
Correct answer: Filtering early makes the inputs to later operations, such as joins, much smaller
A join on 100 rows is far cheaper than a join on 5,000.
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 →