Pity Following Query Transform Optimized Operator Tree Using Restructuring Algorithm Selec Q43786738
pity the following query, and transform it into an optimized operator tree using the restructuring algorithm, where select and proiect operations are app as soon as possible to reduce the size of intermediate relations. SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE (DUR > 12 OR RESP = “Analyst”) AND EMP.ENO = ASG.ENO AND (TITLE = “Elect. Eng.” OR ASG.PNO < “P3″) AND (DUR > 12 OR RESP NOT=”Analyst”) AND ASG.PNO = PROJ.PNO Show transcribed image text pity the following query, and transform it into an optimized operator tree using the restructuring algorithm, where select and proiect operations are app as soon as possible to reduce the size of intermediate relations. SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE (DUR > 12 OR RESP = “Analyst”) AND EMP.ENO = ASG.ENO AND (TITLE = “Elect. Eng.” OR ASG.PNO 12 OR RESP NOT=”Analyst”) AND ASG.PNO = PROJ.PNO
Expert Answer
Answer to pity the following query, and transform it into an optimized operator tree using the restructuring algorithm, where sele…
OR