topic Re: Performance tuning on SELECT Statement in Application Development and Automation Discussions

Performance tuning on SELECT Statement

Former Member — Tue, 09 Sep 2014 03:47:47 GMT

Hi all,

Good day!

I would like to ask for your assistance on this,

SELECT SINGLE *
FROM zcp_dt_spas_main
INTO CORRESPONDING FIELDS OF wa_spasmain
WHERE pa_partner EQ m_crn-partner and ( penstat = 'A' or ( penstat = 'S' and parfs in ('C','N') ) ).

using SAT transaction code, it has a large execution time/run time.

How can tune this select statement to make it run faster than it is doing now?

Thank you so much.

Best regards.

Re: Performance tuning on SELECT Statement

custodio_deoliveira — Tue, 09 Sep 2014 03:51:20 GMT

Hi Almighty,

It's nearly imposible to help you if we don't know your Z table. What's the primary key? Is there any index? Is it a transparent table?

Cheers,

Custodio

Re: Performance tuning on SELECT Statement

Former Member — Tue, 09 Sep 2014 03:54:10 GMT

Hi,

Pass primary key fields in where condition.

Re: Performance tuning on SELECT Statement

former_member249399 — Tue, 09 Sep 2014 03:54:31 GMT

You can try with removing 'INTO CORRESPONDING FIELDS ' and

SELECT single field name

FROM zcp_dt_spas_main
INTO wa_spasmain
WHERE pa_partner EQ m_crn-partner

and penstat in ('A' 'S')

and parfs in ('C','N').

Re: Performance tuning on SELECT Statement

custodio_deoliveira — Tue, 09 Sep 2014 03:57:56 GMT

How do you know this is a better option without knowing the structure of zcp_dt_spas_main and wa_spasmain? This could easily generate a short dump, i.e. if the structures are different and a numeric target field is receiving a non numeric character.

Re: Performance tuning on SELECT Statement

Former Member — Tue, 09 Sep 2014 04:01:21 GMT

sorry i didnt mentioned it. It is a transparent table Sir.

Re: Performance tuning on SELECT Statement

Former Member — Tue, 09 Sep 2014 04:05:46 GMT

Hi,

I have tune your select statement.

Try using the code below code.

data : wa_spasmain type zcp_dt_spas_main.

select single *

FROM zcp_dt_spas_main

into wa_spasmain

WHERE pa_partner EQ m_crn-partner

if sy-subrc eq 0.

if penstat = 'A' or ( penstat = 'S' and parfs in ('C','N') )

............ write further code here.

endif.

Regards,

Dev