|
I have a SQLRPG program, and it has multiple SQL Statements. When I run PRTSQLINF for this program, it shows the estimated query run time, and most of them have 1second estimated run time, but one of them has 8 seconds estimated run time. Statement:- "C+ SELECT DISTINCT PTCNTL C+ INTO :CNTL FROM EPTMST C+ WHERE PTCNTL = :SCTL03 AND C+ PTCMPY BETWEEN :S2LCO AND :S2HCO AND C+ PTLOC BETWEEN :S2LLC AND :S2HLC" SQL4021 Access plan last saved on 09/05/05 at 11:53:23. SQL4020 Estimated query run time is 8 seconds. SQL402D Query attributes overridden from query options file QAQQINI in library QUSRSYS. SQL4017 Host variables implemented as reusable ODP. SQL4010 Table scan access for table 1. My question is, is this estimated time really denotes the performance of the program. And if yes, how can I improve the performance of it. Waiting for reply AH
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.