Skip to Content
1
Jun 03, 2020 at 08:54 PM

Select LIPS bad performance

368 Views Last edit Jun 03, 2020 at 08:56 PM 2 rev

Hello,

This Select from LIPS table takes too long, actually ends in a TIME OUT in production system.

LIPS table has only about 140.000 records.

Internal tabla LT_AUX has only 3 records ! It's not empty...

We are accesing using the key fields:

I did the same select in SE16 and its very fast.

I've made a ST05 trace in quality system and see the following:

Why it's doing these nested loops??

Thanks.

Attachments

tables.png (145.1 kB)
st05.png (205.0 kB)
select.png (32.2 kB)