topic Re: Performance Issues while executing LT27 transaction in Application Development and Automation Discussions

Performance Issues while executing LT27 transaction

Former Member — Tue, 11 Sep 2007 14:11:24 GMT

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.

Re: Performance Issues while executing LT27 transaction

Former Member — Tue, 11 Sep 2007 14:32:44 GMT

Do a performance trace and see if it is using any index. It looks like it shoould use index LTAP~M.

Rob

Re: Performance Issues while executing LT27 transaction

Former Member — Thu, 13 Sep 2007 15:56:31 GMT

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.

Re: Performance Issues while executing LT27 transaction

Former Member — Mon, 30 Nov 2009 15:05:17 GMT

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.