How a Join is Processed

• First the system obtains the Cartesian Product of all tables in joinCartesian Product - the matrix of all possible combinations that could satisfy the join

• The select list is used to restrict the columns returned

• The WHERE clause is then used to restrict the rows return that satisfy the query

Previous slide

Next slide

Back to first slide

View graphic version