10 likes | 92 Views
(On-the-fly). (Index Nested Loops). (Index Nested Loops). (On-the-fly). did= d id. did= d id. (On-the-fly). did. (On-the-fly). (File Scan). did, dname. budget,did. D.dname , F.budget. Sal > 59000 ∩ hobby = ‘ yodelling ’ . (File Scan). F. floor = 1. (Use Index Emp.sal).
E N D
(On-the-fly) (Index Nested Loops) (Index Nested Loops) (On-the-fly) did=did did=did (On-the-fly) did (On-the-fly) (File Scan) did, dname budget,did D.dname, F.budget Sal > 59000 ∩ hobby = ‘yodelling’ (File Scan) F floor = 1 (Use Index Emp.sal) E D