Looking Ahead: Query Processing
Order of operations affects efficiency
Example: ?(R1) *?(R2) probably much faster than ?(R1 * R2)
Large joins can be particularly taxing
Ideally, we do not let this affect how we write queries!
Smart DBMSs do "query optimization"
- automatically reorder operations for efficiency