topic Re: Expensive statement on DB in Application Development and Automation Discussions

Expensive statement on DB

Former Member — Mon, 06 Apr 2009 13:16:40 GMT

Hi,

The following statement is expensive on the database. Kindly provide me the certain change to improve the performance.

refresh i_hrp1000.

select objid begda endda mc_short from hrp1000 into table i_hrp1000

where plvar = c_plvar

and otype = c_otype

and istat = c_istat

and langu = sy-langu.

Rgs

Krishna

Re: Expensive statement on DB

former_member156446 — Mon, 06 Apr 2009 13:24:18 GMT

if you can use all the below fields in your select it would be more effeciant:

PLVAR OTYPE OBJID ISTAT BEGDA ENDDA LANGU SEQNR, these are the primary keys

Re: Expensive statement on DB

Former Member — Mon, 06 Apr 2009 13:29:13 GMT

check the below FM

RH_READ_INFTY_1000

Re: Expensive statement on DB

Former Member — Mon, 06 Apr 2009 13:29:57 GMT

Hi Krishna,

try to add additionla parameters and set some default values to minimize the select statement.


    select single
           objid begda endda mc_short
           from hrp1000
           into l_pdesc
           where otype = c_otype
           and objid = pernr-plans    "<<  pass this
           and istat = '1'                  "<<pass this
           and begda le sy-datum   "<<pass this
           and endda ge sy-datum.  "<<pass this

Regards,

Prabhudas