Question

Optimize the following query using heuristic query optimization.
SELECT P.Number, P.Dnum, E.Lname, E.Address, E.Bdate FROM PROJECT AS P,DEPARTMENT AS D, EMPLOYEE AS E WHERE P.Dnum=D.Dnumber AND D.Mgrssn=E.Ssn AND P.Plocation=‘stafford’;

Answer 1

Answer:

no no no no no no no no no nono no no no no no no no no no