كيف بامكاني تسريع هذه الجملة الرجاء المساعدة بسرعة

[joudeh83]

تسريع هذه الجملة حيث تتجاوز ال 24 ساعة ويفصل معي .من يستطيع مساعدتي بتسريعها علما بانها من الEBS


SELECT DISTINCT
PPF.EMPLOYEE_NUMBER,
PPF.FULL_NAME,
PAD.JOB,
--PAD.LOCATION,
PAD.ORGANIZATION,
P.ABSENCE_ATTENDANCE_TYPE_ID,
A.NAME,
-- P.DATE_START,
--P.DATE_END,
--P.ABSENCE_DAYS,
--PAD.ASSIGNMENT_ID,
PER_UTILITY_FUNCTIONS.GET_NET_ACCRUAL (
PAD.ASSIGNMENT_id,
61,
Ppf.Business_Group_ID,
NULL,
--SYSDATE, --to_date('30/06/2011','dd/mm/yyyy'),--SYSDATE,
ADD_MONTHS (TRUNC (SYSDATE, 'YEAR'), 12) - 1,
61,
NULL,
NULL
)
NET_ACCRUAL
FROM per_all_assignments_d PAD,
per_all_PEOPLE_F PPF,
PER_ABSENCE_ATTENDANCE_TYPES A,
HR.PER_ABSENCE_ATTENDANCES P
WHERE PAD.ASSIGNMENT_NUMBER = PPF.EMPLOYEE_NUMBER
AND PAD.ASSIGNMENT_ID in(1202)--,846,1203)
and Ppf.Business_Group_ID= 109
--and PPF.EMPLOYEE_NUMBER= '343'
AND PPF.EMPLOYEE_NUMBER IS NOT NULL
AND A.ABSENCE_ATTENDANCE_TYPE_ID = 65 --NOT IN (70, 71, 72)
AND PPF.effective_start_date =
(SELECT MAX (d.effective_start_date)
FROM per_all_people_f d
WHERE PAD.ASSIGNMENT_NUMBER = D.EMPLOYEE_NUMBER)
AND Pad.effective_start_date =
(SELECT MAX (dd.effective_start_date)
FROM per_all_assignments_d dd
WHERE PAD.ASSIGNMENT_id = dd.ASSIGNMENT_id)
AND A.ABSENCE_ATTENDANCE_TYPE_ID = P.ABSENCE_ATTENDANCE_TYPE_ID
--AND P.PERSON_ID = PPF.PERSON_ID(+)
--AND PPF.effective_END_date > SYSDATE
AND Pad.effective_END_date > SYSDATE
--AND TO_CHAR (P.DATE_START, 'YYYY') = TO_CHAR (:from_date, 'YYYY')
--AND PPF.EMPLOYEE_NUMBER = NVL (_emp_no, PPF.EMPLOYEE_NUMBER)
AND TO_CHAR (P.DATE_START, 'YYYY') = TO_CHAR (SYSDATE, 'YYYY')
ORDER BY PPF.EMPLOYEE_NUMBER;