topic Re: select single * slows down report in Application Development and Automation Discussions

select single * slows down report

Former Member — Mon, 22 Oct 2007 09:37:43 GMT

hi guys,

how to tune up :

SELECT SINGLE * FROM bkpf WHERE bukrs EQ bsis-bukrs

AND belnr EQ bsis-belnr

AND gjahr EQ bsis-gjahr.

SELECT SINGLE * FROM bseg WHERE bukrs EQ bsis-bukrs

AND belnr EQ bsis-belnr

AND gjahr EQ bsis-gjahr

AND buzei EQ bsis-buzei.

these 2 really slows down the report

Re: select single * slows down report

Former Member — Mon, 22 Oct 2007 09:40:19 GMT

Hi,

It should not happen.

Can you check once again where is it taking more time.

These two should take very less time.

Regards,

Atish

Re: select single * slows down report

Former Member — Mon, 22 Oct 2007 09:46:40 GMT

well i suppose you got those 2 select single ´s in a loop, or even a nested loop.

and in this case, YEAH select single is SLOW.

what you can do:

- make an array fetch of bkpf and bseg into internal tables right at the start, and then do read table instead of selects in your loop..

- make NOT select single *, but select single fieldlist.

where fieldlist specifies the fields you need.

Re: select single * slows down report

paruchuri_nagesh — Mon, 22 Oct 2007 09:47:45 GMT

if u r using non primary key fields in where condition of select single * then it slow down the report other wise it wont.

regards

Nagesh.Paruchuri

Re: select single * slows down report

Former Member — Mon, 22 Oct 2007 09:48:47 GMT

Hi,

Check whether u have mentioned the INTO workarea clause in your query...

Since u have used all the key fields with ur SELECT SINGLE query this will not cause performance issue...

Do reward points if useful..

Thanks and regards,

Litta.

Re: select single * slows down report

Former Member — Mon, 22 Oct 2007 09:49:56 GMT

Hi,

Instead of select single use the select into table with for all entries outside the loop . if u r fetching only one record use select single with alll key fields.

It will improve the performance.

Regards,

Nandha

Re: select single * slows down report

rainer_hbenthal — Mon, 22 Oct 2007 10:29:11 GMT

You used all fields in the index, so this should not cause performance problems. It it is called many many times think about doing a prefetch of all nedded values at startup into an internal table.

Re: select single * slows down report

Former Member — Mon, 22 Oct 2007 10:32:51 GMT

SELECT SINGLE * FROM bkpf WHERE bukrs EQ bsis-bukrs

AND belnr EQ bsis-belnr

AND gjahr EQ bsis-gjahr.

SELECT SINGLE * FROM bseg WHERE bukrs EQ bsis-bukrs

AND belnr EQ bsis-belnr

AND gjahr EQ bsis-gjahr

AND buzei EQ bsis-buzei.

Are u using the Database table BSIS in the where clause.,.,it is a problem there fore it is taking time.

Instead first select the values of BUKRS,BELNR,GJAHR,BUZEI from the table BSIS.,.,into an internal table.

Then write the above select statement giving The internal Table name instade of the BSIS table name and Provide the INTO clause also .

Regards

Debasish

Re: select single * slows down report

harimanjesh_an — Mon, 22 Oct 2007 11:28:49 GMT

hi ester......

To improve the performance, u have to use INTO clause.....

DATA : wa_bkpf TYPE bkpf,

wa_bseg TYPE bseg.

SELECT SINGLE *

FROM bkpf

INTO wa_bkpf

WHERE bukrs EQ bsis-bukrs

AND belnr EQ bsis-belnr

AND gjahr EQ bsis-gjahr.

SELECT SINGLE *

FROM bseg

INTO wa_bseg

WHERE bukrs EQ bsis-bukrs

AND belnr EQ bsis-belnr

AND gjahr EQ bsis-gjahr

AND buzei EQ bsis-buzei.

This will definitely improve the performance.....

Reward me if useful...........

Harimanjesh AN

Re: select single * slows down report

Former Member — Mon, 22 Oct 2007 14:04:43 GMT

This should be very quick, so your problem is likely elsewhere. Have you run ST05 on the report?

Rob