Slow Select Statement from a Custom Field of Custom Table.
Kindly assist me on how to make my code run faster. I made a custom field with 50 characters and include it to a custom field. The program really took a long time in processing the program segment where I'm getting the rows that match the custom field.
here is my pseudocode:
loop at it_tab. select zfield into it_tab-zfield from ztable where standard_field eq it_tab-standard_field. endselect. if it_tab-zfield ne ''. select min( standard_date ) into it_tab-standard_date from ztable where zfield eq it_tab-zfield. endselect. else. it_tab-standard_date = 1. endif. modify it_tab. endloop. clear: it_tab " I put a breakpoint to this line and the system took more than 5 mins to display the debugger window.
I already put index on our custom field on that custom table yet, the performace does not change.
I hope you can help me with this issue.