09-11-2007 3:11 PM
We are getting a 'Time Out' error while executing the transaction LT27. The reason for this is an expensive select statement on LTAP in the standard code given below.
select * from LTAP appending table iltap
where nlenr eq lagerein
and lgnum eq lagernum
and pquit eq con_x
and kzsub in kzsub_tab
and (DS_clauses-where_tab)
%_HINTS
DB2 '&SUBSTITUTE LITERALS&'
DB6 '&SUBSTITUTE LITERALS&'
ORACLE '&SUBSTITUTE LITERALS&'
MSSQLNT '&SUBSTITUTE LITERALS&'.
One possibe solution for this is to create a secondary index on NLENR field but we want to avoid that because we already have 5 secondary Indices on LTAP. We already implemented the SAP note 999743 but it was of no use. Please reply ASAP.
09-11-2007 3:32 PM
Do a performance trace and see if it is using any index. It looks like it shoould use index LTAP~M.
Rob
09-13-2007 4:56 PM
Thanks for your response Rob. I did run the SQL trace for the transaction and it was pointing to one of the custom Index that we created. We decided not to go ahead with the Index creation anymore because the performance increases remarkably when we add additional selection criteria by checking the Additional selections box.
Arun.
11-30-2009 3:05 PM
Hi Arun,
We are facing the same peroformance issue with LT27 . To overcome it we created a secondary index in table LTAP , already there are 5 indexes in table LTAP , its performance improved a lot , but it effected the performance of LT22 which uses the same table LTAP. We wanted to know more how you got resolved the issue by creating an additional selection criteria.
I shall be thankful for you , if you can recall the issue and respond.
Thanks
Vengal Rao.