Skip to Content
0
Dec 01, 2009 at 05:31 AM

DATABASE performance is very high

53 Views

Hi,

I'm having the following code. its performance is very high. Is it possible to reduce the processing time?

SELECT objnr gjahr kstar beknz twaer

wtg001 wtg002 wtg003 wtg004 wtg005 wtg006

wtg007 wtg008 wtg009 wtg010 wtg011 wtg012

wkg001 wkg002 wkg003 wkg004 wkg005 wkg006

wkg007 wkg008 wkg009 wkg010 wkg011 wkg012

wog001 wog002 wog003 wog004 wog005 wog006

wog007 wog008 wog009 wog010 wog011 wog012

FROM cosp APPENDING TABLE i_cosp_t PACKAGE SIZE 2000

  • FOR ALL ENTRIES IN p_i_vbakp

WHERE lednr EQ c_lednr_0 AND

versn EQ c_versn_0 AND

gjahr EQ p_gjahr AND

wrttp EQ c_wrttp AND

kstar IN p_r_kstar_cosp.

ENDSELECT.

  • READ TABLE COSS AND APPEND TO P_I_COSP FILLED ABOVE

SELECT objnr gjahr kstar uspob beknz twaer

wtg001 wtg002 wtg003 wtg004 wtg005 wtg006

wtg007 wtg008 wtg009 wtg010 wtg011 wtg012

wkg001 wkg002 wkg003 wkg004 wkg005 wkg006

wkg007 wkg008 wkg009 wkg010 wkg011 wkg012

wog001 wog002 wog003 wog004 wog005 wog006

wog007 wog008 wog009 wog010 wog011 wog012

FROM coss APPENDING TABLE i_coss_t PACKAGE SIZE 2000

  • FOR ALL ENTRIES IN p_i_vbakp

WHERE lednr EQ c_lednr_0 AND

versn EQ c_versn_0 AND

gjahr EQ p_gjahr AND

wrttp EQ c_wrttp AND

kstar IN p_r_kstar_coss.

ENDSELECT.

Thanks & Regards,

Vallamuthu.M