Optimize the following SQL Query by using Query Tree and Heuristic Rules:
SELECT C.Fname, E.Fname
FROM Employee AS E, Customer AS C, Order AS O
WHERE E.EMP_ID=O.E_ID AND C.City=Jeddah AND C.Customer_ID=O.C_ID AND E.EMP_ID=12943
You should show the Initial Query Tree and add a screenshot of the Query Tree after applying each rule.
