Join Example (cont)
Out = Student ⋈ Enrolled relation statistics:
| Sym |
Meaning |
Value |
| rOut |
# tuples in result |
80,000 |
| COut |
result records/page |
80 |
| bOut |
# data pages in result |
1,000 |
Notes:
- rOut ... one result tuple for each
Enrolled tuple
- COut ... result tuples have only
subj and name
- in analyses, ignore cost of writing result ... same in all methods
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}