Terminology Variations
Relational algebra expression of SQL query
- intermediate query representation
- logical query plan
Execution plan as collection of RelOps
- query evaluation plan
- query execution plan
- physical query plan
Representation of RA operators and expressions
- σ = Select = Sel,
π = Project = Proj
- R ⋈ S = R Join S = Join(R,S),
∧ = &, ∨ = |
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}