| Urgent:-SQL taking long time to execute [message #65523] |
Wed, 13 October 2004 00:01  |
sangeeta Prabhu
Messages: 8
Registered: October 2004
|
Junior Member |
|
|
Hi all,
This query is taking a long time to execute.
can anybody suggest any changes regarding any hint or rewriting the query.
select TO_CHAR(DDI.SNAPSHOT_D, 'mm/dd/yyyy') Modified_On,
trim(WHO.EMP_FRST_N) || ' ' || WHO.EMP_LAST_N Modified_By,
DDI.OBJ_GRP_T DI_Type,
RECIP.RECPT_INDIV_N Participant_Name,
RECIP.RECPT_ORG_N Company_Name,
RECIP.AUX_ST_ADDR_T || RECIP.AUX_ST_ADDR_2_T || RECIP.AUX_ST_ADDR_3_T || ',' ||
RECIP.ADDR_CITY_N || ' ' || RECIP.STATE_N || '-' || RECIP.ZIP_1_ID_C Address,
RECIP.PHONE_ID_C Phone,
RECIP.FAX_ID_C Fax,
SACCT.COND_CMT_T SpecificCondition,
OT.DEL_OBJ_DESC_T DeliveryObject,
LT.SUIT_TYP_DESC_T SuitType
from CUS.HDI_ACCOUNT ddi,
CUS.TOPERATIONAL_RES who,
CUS.HRECIPIENT recip,
CUS.HDI_SOP_COND scond,
CUS.HSOP_DC_ACCOUNT sacct,
CUS.TDEL_OBJECT_TYPE ot,
CUS.TLAWSUIT_TYPE lt
where DDI.MODIFIED_BY_C = WHO.EMP_ID_C and
DDI.RECPT_ID_C = RECIP.RECPT_ID_C and
DDI.SNAPSHOT_D = RECIP.SNAPSHOT_D and
SCOND.SNAPSHOT_D(+) = DDI.SNAPSHOT_D and
SCOND.RECPT_ID_C(+) = DDI.RECPT_ID_C and
SCOND.ACCT_ID_C(+) = DDI.ACCT_ID_C and
SACCT.ACCT_ID_C(+) = SCOND.ACCT_ID_C and
SACCT.SOP_DEL_COND_ID_C(+) = SCOND.SOP_DEL_COND_ID_C and
SACCT.SNAPSHOT_D(+) = SCOND.SNAPSHOT_D and
OT.OBJ_GRP_T(+) = SCOND.OBJ_GRP_T and
OT.DEL_OBJ_C(+) = SCOND.DEL_OBJ_C and
LT.SUIT_TYP_C(+) = SACCT.SUIT_TYP_C
Thanks in Advance
Sangeeta
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
