You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
33 lines
803 B
33 lines
803 B
⍵ {
|
|
_ Fine
|
|
_ r.dday → r.dday, r.bid → r.bid, r.sid → r.sid, s.age → s.age, s.rating → s.rating, s.sname → s.sname, s.sid → s.sid
|
|
_ x_0.s.sid = x_0.r.sid
|
|
_ {
|
|
⍵ {
|
|
_ Fine
|
|
_ sid → s.sid, sname → s.sname, rating → s.rating, age → s.age
|
|
_ ⊤
|
|
_ {
|
|
Seq Scan on sailors
|
|
}
|
|
}
|
|
× (DependentJoin) (Hash Join)
|
|
Label: Hash
|
|
⍵ {
|
|
_ Partition (x_0.r.sid)
|
|
_ r.sid → r.sid, r.bid → r.bid, r.dday → r.dday
|
|
_ ⊤
|
|
_ {
|
|
Label: Aggregate
|
|
⍵ {
|
|
_ Fine
|
|
_ sid → r.sid, bid → r.bid, dday → r.dday
|
|
_ x_0.bid = 103
|
|
_ {
|
|
Seq Scan on reserves
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|