Performance tuning on SELECT Statement
I would like to ask for your assistance on this,
SELECT SINGLE *
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.