Top-Down SQL Tuning

First Fix, Problem 8

Don’t lose records just because they were recorded by someone who is no longer an employee!

SELECT C.Last_Name, C.First_Name, CE.Event_Date, Ev.Name, EM.Last_Name, Em.First_Name

FROM Customers C, Customer_Events CE, Events Ev, Employees Em

WHERE C.Customer_ID = :B1

AND C.Customer_ID = CE.Customer_ID

AND CE.Event_ID = Ev.Event_ID

AND CE.Recorded_By = Em.Employee_ID(+)

ORDER BY CE.Event_Date;