Skip to Content
0

Working with index

Mar 29, 2017 at 08:29 AM

15

avatar image

Hello Experts,

I need to Access to table LTBP using field lgnum, elikz and matnr. The matnr is a select options in the selection screen of the report which is not mandatory.

I've checked that the table LTBP has M index which I suppose it was better than the index 0. My surprise was that, when I execute the report with the material empty (so select everything) and for specific lgnum, the runtime analisys returns 125.000.000 but when I execute it without forcing index M, it costs 95.473.974.

But, if I execute it just for one material:

Index M returns 5.807 meanwhile index 0 returns 25.087

Regarding to performance, when an index is used, it will be necessary that the select contains the whole index filled without the possibility of being empty? So in this case, it will be better to use index 0 instead of index M?

Thanks for your support.

Best regards,


Rebeca

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers