Naïve Query Processing
SELECT LNAME
FROM EMPLOYEE, DEPARTMENT
WHERE DNO=DNUMBER AND SALARY AND DNAME="Software Support";
Naively, this is 1 Cartesian product, followed by 3 selects, followed by one project.
Query tree is drawn from bottom up.
Previous slide
Next slide
Back to first slide
View graphic version