•Scan ([index], table,
predicate):
–Either index scan or table
scan.
–Try to push down sargable predicates.
•Selection (filter)
•Projection (always need to go to
the data?)
•Joins: nested loop (indexed),
sort-merge, hash, outer join.
•Grouping and aggregation
(usually the last).