Expectations of Simple Queries
•Query maps to one tree.
•The tree has one root, exactly one table with no join to its primary
key.
•All
joins have downward-pointing arrows (joins unique on one end).•Outer
joins point down, with only outer joins below outer joins.
S P
O ODT
OD
A OT C
