We have been running queries and loading PLM material for aircraft parts and the system is really slow. I captured the sql statement via ST05 and found the highest time periods were not inserts but rather the highest was the FETCH operation.
The explain statement shows execution plan shows 1 and the proper index. The optimizer is working properly.
What is the FETCH and how can we tune the fetch process to reduce the time to respond.