Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance tuning on SELECT Statement

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question