Skip to Content
0
Former Member
Jun 03, 2009 at 09:08 AM

Performance tuning to SWWWIHEAD table extraction.

288 Views

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