Started a new transaction tid = 5
Added scan of table emp
Added scan of table dept
Added scan of table hobbies
Added scan of table hobby
Added join between emp.c1 and dept.c0
Added join between hobbies.c0 and emp.c2
Added join between hobbies.c1 and hobby.c0
Added select list field null.*
The query plan is:
π(emp.c0,emp.c1,emp.c2,emp.c3,emp.c4,emp.c5,dept.c0,dept.c1,dept.c2,hobbies.c0,hobbies.c1,hobby.c0,hobby.c1,hobby.c2,hobby.c3,hobby.c4,hobby.c5),card:200000
|
⨝(hobbies.c1=hobby.c0),card:200000
__________________|__________________
| |
⨝(emp.c2=hobbies.c0),card:200000 |
_______________|________________ |
| | |
⨝(emp.c1=dept.c0),card:1515 | |
______________|______________ | |
| | | |
σ(emp.c3<1000),card:1515 | | |
| | scan(hobbies) |
scan(emp) scan(dept) scan(hobby)
emp.c0 emp.c1 emp.c2 emp.c3 emp.c4 emp.c5 dept.c0 dept.c1 dept.c2 hobbies.c0 hobbies.c1 hobby.c0 hobby.c1 hobby.c2 hobby.c3 hobby.c4 hobby.c5
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
14886 43334 25034 280 16861 13109 43334 32032 56577 25034 19709 19709 40829 59152 46562 16985 57422
14886 43334 25034 280 16861 13109 43334 32032 56577 25034 38158 38158 9948 57639 4440 11109 19862
34917 39222 31124 581 38547 34833 39222 43620 49571 31124 62585 62585 8114 3830 47679 51416 58388
3 rows.
Transaction 5 committed.