20 likes | 119 Views
BASIS DATA. 21 Query Tree ( Pushing Selection Down ). 1. Pushing Selection Down. π P.PNUMBER, D.DNUMBER, E.LNAME, E.ADDRESS, E.BDATE δ E.SSN=D.MGRSSN X δ D. DNUMBER = P.DNUM ^ X E
E N D
BASIS DATA 21 Query Tree (Pushing Selection Down ) 1
Pushing Selection Down πP.PNUMBER, D.DNUMBER, E.LNAME, E.ADDRESS, E.BDATE δ E.SSN=D.MGRSSN X δ D.DNUMBER = P.DNUM ^ X E δP.PLOCATION= “Stafford” ^ P D