Joining Tables: Table Order

Consider the select:

Select * from A, B

where A.join_col = B.join_col

How can the database satisfy this join?

• Read from A then find matching rows in B
• Read from B then find matching rows in A

Previous slide

Next slide

Back to first slide

View graphic version