Home » RDBMS Server » Performance Tuning » Urgent:-SQL taking long time to execute
Urgent:-SQL taking long time to execute [message #65523] Wed, 13 October 2004 00:01 Go to next message
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

 
Re: Urgent:-SQL taking long time to execute [message #65531 is a reply to message #65523] Sat, 16 October 2004 20:49 Go to previous message
easyweb
Messages: 3
Registered: October 2004
Junior Member
Too mach tables, better to denormalize it, after that check indexes

www.easywebtech.com
Previous Topic: Terms meaning in V$SYSSTAT
Next Topic: Bequeth connections and memory usage in 8i
Goto Forum:
  


Current Time: Thu Mar 28 12:36:59 CDT 2024