Skip to Content
avatar image
Former Member

Working with index

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers