🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Relational Algebra: all 15 questions

Quiz: Relational Algebra · Question 8 of 15

Why do query optimizers push selections below joins?

Why do query optimizers push selections below joins?

  1. A.It changes the result to be more accurate
  2. B.Fewer rows go into the join, so less work is done for the same result
  3. C.Joins cannot run after selections
  4. D.It removes duplicates
Answer & explanation

Correct answer: Fewer rows go into the join, so less work is done for the same result

Filtering early is cheaper and gives an equivalent result.

Can you get the rest right without peeking?

Take the timed Quiz: Relational Algebra quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →