🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.It removes the need for indexes
  2. B.It sorts the rows
  3. C.Filtering early makes the inputs to later operations, such as joins, much smaller
  4. 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 →