Performance issue with select query
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.