topic Performance Issue in Select statement in Application Development and Automation Discussions

Performance Issue in Select statement

Former Member — Tue, 10 Jan 2006 08:09:22 GMT

Hi ,

I have a select statement in my program as below:

select bukrs belnr gjahr blart bldat budat monat

cpudt tcode waers bstat psobt

into table t_bkpf

from bkpf

where bukrs in s_bukrs and

budat in s_budat and

monat = p_monat and

blart = p_blart.

This takes long time to fetch data. Could someone help me improving the performance of the statement.

Re: Performance Issue in Select statement

abdul_hakim — Tue, 10 Jan 2006 08:16:57 GMT

Your SELECT statement looks ok for me.

Well if possible add the following also in the WHERE condition,

belnr,

gjahr

Abdul

Re: Performance Issue in Select statement

FredericGirod — Tue, 10 Jan 2006 08:17:54 GMT

Hi Sumi,

maybe start to had the GJAHR in your selection criteria.

and check your index, that must feet the selection criteria.

Rgd

Frédéric

Re: Performance Issue in Select statement

Former Member — Tue, 10 Jan 2006 08:18:04 GMT

Hi Sumi,

1. The sql is perfectly ok.

2. With some constraints, (if possible)

we can do this :

a) take bukrs as parameter (instead of select-option)

so that sql is bukrs = s_bukrs

b)arrange the sequencde of where conditions as

bukrs

blart

bldat

monat

e) Still, want more perfroamnce, then

final optino is :

SECONDARY INDEX

(using se11)

on fields

budat, monat , blart

(this will imporove the performance DRASTICALLY)

regards,

amit m.

Re: Performance Issue in Select statement

Former Member — Tue, 10 Jan 2006 08:18:12 GMT

Adding to what Abdul said , Also check if the parameters or select options which you are passing is blank or not.

Ankur Bhandari

Re: Performance Issue in Select statement

FredericGirod — Tue, 10 Jan 2006 08:27:47 GMT

And sometimes, when you know the size of the data you will have, you could specify the good size of the internal table. But that could be dangerous.

Fred