I am monitoring performance of transaction Vl01n. The workload table access statistics(St03n) for this transaction shows 0 modificatios, 0 direct reads, 0 sequential reads on table LTAK and has the top access time for the transaction (almost 90% of the total response time of the transaction).
My question here is that, <b>what other operation can cause such high response time when the Workload shows 0 modificatios, 0 direct reads, 0 sequential reads.</b>
Also the STAD data shows that this transaction has high response time with LTAK being the major contributor, when the Work process type Is <b>'U'</b>. Can we make assumptions that the operation being performed is Update?