Skip to Content
Former Member
May 03, 2007 at 10:31 PM

FETCH in ST05 is huge; what is the FETCH and how do I tune it


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.