topic Re: Performance issue with select query in Application Development and Automation Discussions

Performance issue with select query

Former Member — Thu, 25 Oct 2007 06:11:01 GMT

Hi,

i have a performance issue with below query...its taking lots of time to execute.

********************************

We have a selection screen with Idoc creation date field only, so screen should allow user the enter startdate and end date of idoc received.

SELECT docnum status direct credat mestyp idoctp

FROM edidc

INTO CORRESPONDING FIELDS OF TABLE i_edidc

WHERE status = '53' AND

direct = '2' AND

credat IN s_credat AND

mestyp = 'CREMAS' AND

idoctp = 'CREMAS03'.

*******************************************

Pls review and suggest me, how we can improve the performance.

Re: Performance issue with select query

Sathish — Thu, 25 Oct 2007 06:34:11 GMT

How many values are there in s_credat?

The performance could be affected if there are lot number of records in s_credat.

Re: Performance issue with select query

Rodrigo-Giner — Thu, 25 Oct 2007 20:29:48 GMT

Here r some advices:

1- IF u use one IN statment in the where clause, use all IN. Put the "hardcoded" Values in the s_option-low field.

2- Try not to use CORRESPONDING FIELDS OF. Instead Declare i_edidc like this:

DATA: Begin of i_edidc occurs 0,

docnum TYPE edidc-docnum,

status TYPE edidc-status,

vdirect TYPE edidc-vdirect,

credat TYPE edidc-credat,

mestyp TYPE edidc-mestyp,

idoctp TYPE edidc-idoctp,

END OF i_edidc.

And use INTO TABLE i_edidc

SELECT docnum status direct credat mestyp idoctp

FROM edidc

INTO TABLE i_edidc

WHERE status IN s_status AND

direct IN s_direct AND

credat IN s_credat AND

mestyp IN s_mestyp AND

idoctp IN s_idoctp.

Re: Performance issue with select query

former_member195698 — Thu, 25 Oct 2007 21:55:10 GMT

Hi,

Give the fields in the where condition in the sames sequence as present in the database. Also the fields which are selected should be in the same sequence as present in the database.

Try creating an index on the table based on the query if advisable.

Regards,

Abhishek