topic Re: Select poor performance in Application Development and Automation Discussions

Select poor performance

Former Member — Tue, 08 Apr 2008 11:34:27 GMT

Good morning:

I have to select some records from BSAK and i want to have better performance, i am not using all the fields of the table key, i have been seeing in thsi forum some people recomending to create new select-options for this key fields, i want to know if i create renges and left them in blank if it would have better performance.

Thanks in advance.

Regards

Example

ranges r_bukrs like bsak-bukrs."Always empty

select * from bsak into table it_bsak where bukrs in r_bukrs

is better than

select * from bsak into table it_bsak

Re: Select poor performance

Former Member — Tue, 08 Apr 2008 11:41:02 GMT

no, an empty range does not help you.

Since you dont have ANY where condition, you always get the full table.

theres heaploads of data in BSAK, what makes the select perform bad.

eihter add where conditions (best case on key fields)

or do not select *, but only the needed fields.

you can do both as well.

Re: Select poor performance

Former Member — Tue, 08 Apr 2008 11:42:29 GMT

For a start only extract the fields that you are interested in. Remove the SELECT *

Re: Select poor performance

Former Member — Tue, 08 Apr 2008 11:49:38 GMT

Hi,

Creating a select-option n leaving blank wont help, instead u can select some value for tht "select-option" n in the "select criteria" u can make use of tht as a "condition".

Ex: S_VTWEG FOR VBAK-VTWEG OBLIGATORY DEFAULT '10'

IF NOT S_VTWEG[] IS INITIAL.

SELECT SINGLE VTWEG

FROM TVKOV

INTO L_VTWEG

WHERE VTWEG IN S_VTWEG.

I think if u r doin this way...it wud help u ....

Do try this n let me know.

Regards,

Ramya Shree M R