1792694 - HANA-specific performance improvements in LIME

Symptom

1. Selections in LIME table /LIME/NQUAN is not optimal when using HANA database.

2. Selection on table /LIME/NTREE to find gap objects is running too long on HANA DB.

Other Terms

HANA, LIME, LFT

Reason and Prerequisites

1. The indexes on the table are generated for non-HANA databases. However in HANA the usage of MANDT in indexes is not necessary, but it even decreases the search effectivity.

2. If the additional search parameters in the gap selection are initial, this has a negative runtime performance effect in case of HANA database. The additional search parameters are always empty at the first iteration, thus it makes sense to distinguish between this and the next iterations.

Solution

Implement the attached correction instructions or the corresponding support package.

• The newly introduces index will support HANA database searches and it is limited to the HANA DB only, thus it will not affect the performance of normal relational databases.

• The changed code of gap determination logic will have a very significant performance improvement for HANA database, while only a minor for non-HANA cases.

------------------------------------------------------------------------
|Manual Activity                                                       |
------------------------------------------------------------------------
|VALID FOR                                                             |
|Software Component   SAP_AP                        SAP Application...|
| Release 700          Until SAPKNA7028                                |
------------------------------------------------------------------------

Create database table index:

• Start transaction SE11 and open table /LIME/NQUAN.

• Choose function Indexes... in the toolbar.

• On the appearing dialog box choose function Create Index (icon: White empty page) in the toolbar.

• On the following dialog box enter Index name: H01. Choose Continue.

• Add short description: "HANA: LFT".

• Choose "Non-unique index" -> "For selected database systems".

• Click the button next to this option to specify the database name.

• In the dialog box "Database-specific Index" choose option "Selection List".

• Enter DB Name: HDB. Close the dialog.

• Add field LFT to the list "Index flds".

• Save and activate the changes.