###### Expert Q&A

## Apply the dynamic query optimization algorithm to the following query and illustrate the successive detachments and substitutions by giving the…

Question: Apply the dynamic query optimization algorithm to the following query and illustrate the successive detachments and substitutions by giving the monorelation subqueries generated. HINT: Use detachment example from class slides SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE (DUR > 12 OR RESP = “Analyst”) AND EMP.ENO = ASG.ENO Read more…