topic Re: bad performance in Application Development and Automation Discussions

bad performance

Former Member — Fri, 05 Oct 2007 06:27:31 GMT

hi,

am getting very very bad performance with the below select..plz suggest better one

SELECT SINGLE KUNNR FROM BSAD INTO FKUNNR

WHERE BUKRS = FBUKRS

AND KUNNR NE SPACE

AND GJAHR = FGJAHR

AND BELNR = FBELNR

AND BUDAT IN BUDAT.

Re: bad performance

Former Member — Fri, 05 Oct 2007 06:31:19 GMT

Hi,

There is not much you can do with this query.

But can't you use another table as BSAD has very huge amount of data.

Regards,

Atish

Re: bad performance

Former Member — Fri, 05 Oct 2007 09:48:50 GMT

Instead of using BSAD table you can use another table BSEG since you

know the field BUKRS, BELNR and GJAHR.

SELECT SINGLE KUNNR FROM BSEG INTO FKUNNR

WHERE BUKRS = FBUKRS

AND BELNR = FBELNR

AND GJAHR = FGJAHR

AND KOART EQ 'D'. "D IS CUSTOMER ENTRY

Regards

Harish

Re: bad performance

Former Member — Fri, 05 Oct 2007 09:54:13 GMT

Hello Tuborg,

It is also important to know which all values do u know among the 4 passed to select because if FBUKRS,FGJAHR & FBELNR is know then u can directly access BSEG and get the value. However they are not know then u will have to access the BSAD table.

Re: bad performance

Former Member — Wed, 10 Oct 2007 10:20:37 GMT

Hi Tuborg,

If you have all the key fields before the selection, then add those key fields also, which can improve performance.

Thanks and regards

Antony thomas