求一个多表查询SQL的优化。

select a.e_employee_id,a.e_employee_no,a.e_full_name,e.*,c.e_badge_number,b.e_join_date
from (
select e_employee_id,e_employee_no,e_full_name from ev_employee employee where e_deleted =0) a,
(select e_employee_id,e_join_date from ev_emp_job where e_employment_status =1)b,
ev_tms_employee c,
(select e_employee_id from ev_tms_emp_sch_grp_change_tracker where e_current_schedule_group =1) d,
(select e_employee_id,e_attendance_date,e_shift_id,e_late_in,e_early_out,e_break_late_in,e_break_early_out,
e_absence,e_irregular,e_leave_code,e_total_raw_ot_time,e_total_rounded_ot_time,e_total_raw_working_hours,e_approved_ot
from e_tms_attendance_view where e_attendance_date>= '2002-12-01 00:00:00.000' and e_attendance_date <= '2009-01-01 00:00:00.000') e
where a.e_employee_id =b.e_employee_id and a.e_employee_id =c.e_employee_id and a.e_employee_id =d.e_employee_id and a.e_employee_id =e.e_employee_id

~~~~~~~~~~~~~~~~~~~~~~~~~
共计5张表，目前时间大概是1分钟，希望能提高一半的速度。