Tkprof - Elapsed
Dear Experts,
In below tkprof figures,it is the sql that took highest elapsed time. The execution time is less but looks fetch takes more time. From your experince,please let us know the reasons how can we avoid this.
SQL ID: 9w44sa4ant350 Plan Hash: 2559300826 SELECT CHT.CHALLAN_ID, CHT.CHALLAN_AMOUNT, CHT.PROPERTY_ID, CHT.PARTY_ID FROM XXTTD.XXTTD_AR_DCB_CHALLANS_HDR_TBL CHT, XXTTD.XXTTD_AR_DCB_PROP_V DPV, XXTTD.XXTTD_AR_DCB_PROPS_HDR_TBL PHT WHERE DPV.LOCATION_ID = PHT.LOCATION_ID AND PHT.PROPERTY_ID = CHT.PROPERTY_ID AND CHT.ATTRIBUTE2 = 'A' AND CHT.ATTRIBUTE5 = 'A' AND CHT.CHALLAN_DATE BETWEEN :B5 AND :B4 AND CHT.PROPERTY_ID = :B3 AND CHT.PARTY_ID = :B2 AND DPV.PROPERTY_REGION = NVL (:B1 , DPV.PROPERTY_REGION) GROUP BY CHT.CHALLAN_ID, CHT.CHALLAN_AMOUNT, CHT.PROPERTY_ID, CHT.PARTY_ID
0