Performance Issues while executing LT27 transaction

[Former Member]

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.

[Former Member]

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

Rob

[Former Member]

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.

[Former Member]

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.