Show how the query plan shown below is optimized by the DBMS based on query optimization using heuristics

 The initial query plan generated by the SQL query parser of the DBMS is show below

Query:

SELECT Lname

FROM EMPLOYEE, WORKS_ON, PROJECT

WHERE Pname=‘Aquarius’ AND Pnumber=Pno AND Essn=Ssn

AND Bdate > ‘1957-12-31’;

(a) EMPLOYEE Lname | Pname='Aquarius' AND Pnumber=Pno AND Essn=Ssn AND Bdate>'1957-12-31' 1 WORKS ON PROJECT