Which table to filter first
A query joins colleges (400 rows), students (2,000,000 rows) and
submissions (40,000,000 rows), filtering to one college.
Which join order does the least work?
A query joins colleges (400 rows), students (2,000,000 rows) and
submissions (40,000,000 rows), filtering to one college.
Which join order does the least work?