jajularamesh
Beginner
Joined: 14 Apr 2006
Posts: 87
Topics: 33
|
 Posted: Mon Jun 04, 2007 9:28 am Post subject: Can this query be optimized |
 |
|
| Code: |
FROM MUS.T7627_TRAN T27
, MUS.T7617_CLIENT T17
, MUS.T7621_ACCOUNT T21
, MUS.T7626_PRODUCT T26
, MUS.T7628_SLS_PER T28
, MUS.T7628_SLS_PER T28B
, MUS.T7638_FLD_BUS_UNIT T38
, MUS.T7663_REG_REPT_HDR T63
WHERE T27.CRTE_DATE > :HV-TRAN-RUN-DATE
AND T17.CDS_CL_ID = T27.CURR_OWN_CDS_CL_ID
AND T21.CDS_ACCT_ID = T27.CDS_ACCT_ID
AND T26.CDS_PROD_ID = T27.CDS_PROD_ID
AND T28.CDS_SP_ID = T27.CURR_SRV_CDS_SP_ID
AND T38.CDS_FBU_ID = T28.CURR_CDS_AO_FBU_ID
AND T21.CDS_ACCT_ID = T27.CDS_ACCT_ID
AND T26.CDS_PROD_ID = T27.CDS_PROD_ID
AND T28.CDS_SP_ID = T27.CURR_SRV_CDS_SP_ID
AND T38.CDS_FBU_ID = T28.CURR_CDS_AO_FBU_ID
AND T28B.CDS_SP_ID = T27.SERV_MPR_CDS_SP_ID
AND T63.RP_ID = T27.SERV_MPR_CDS_SP_ID
ORDER BY T27.CDS_TRAN_ID
|
Actually here same table given
MUS.T7628_SLS_PER has repeated twice with references T28,T28B i am not sure why this is given like this
Can we use a single reference T28
| Code: |
T28.CDS_SP_ID = T27.CURR_SRV_CDS_SP_ID
T28B.CDS_SP_ID = T27.SERV_MPR_CDS_SP_ID
|
can't we change this as
| Code: |
T28.CDS_SP_ID = T27.CURR_SRV_CDS_SP_ID and
T28.CDS_SP_ID = T27.SERV_MPR_CDS_SP_ID
|
or can't we change like this
| Code: |
T28.CDS_SP_ID = (T27.CURR_SRV_CDS_SP_ID or T27.SERV_MPR_CDS_SP_ID)
|
Actually we are getting some duplicate records which actullay not required
As far as query optimization is concerned what can be done.
Regards,
Ramesh(Venkata Apparao Jajula) |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
