Query Execution Plans

SELECT S.buyer

FROM Purchase P, Person Q

WHERE P.buyer=Q.name AND

Q.city=‘seattle’ AND

Q.phone > ‘5430000’

Query Plan:

• logical tree

• implementation choice at every node

• scheduling of operations.

Some operators are from relational

algebra, and others (e.g., scan, group)

are not.

Previous slide

Next slide

Back to first slide

View graphic version