Dear Guru's/Sifu's,
Would appreicate if anyone can help me to optimized these codes:-
SELECT * FROM swwwihead
appending TABLE g_wi_head_lst
WHERE
wi_type IN r_type AND
wi_stat IN r_wi_stat AND
wi_id IN id AND
wi_text in s_id_txt and
wi_cd IN cd AND
wi_ct IN ct AND
wi_prio IN prio AND
wi_rh_task IN r_task.
What the program does is to extract records from SWWWIHEAD table with only Work item text (WI_TEXT) is filled. Users doesn't fill in any other parameters unless Work Item Text. When I executed ST05, it seems that Full Table Scan (FTS) is done to the table SWWWIHEAD.
Anyone please?. Thank you in advance for your kind assistance.
Regards
Shahrz