Extra indexes on info object attributes

[Former Member]

Hi gurus

We are going to create extra indexes on one of our master data objects. The info object has over 4 million records and it is used a lot in queries. These indexes will have great impact on reporting performance. The question is:

What impact will extra indexes on info object attributes have on master data loading/activation? Is any extra management of these indexes needed?

Kind regards

Erik

[Former Member]

Hi,

depending on how many new records you load, your index will grow or has to be rebuilt. So new indexes reduce speed of master data loading and activation. If possible kepp the indexes as simple and small as possible. E.g. it makes no sense to build an index which has 80% size of master data.

No other extra maintenance necessary, except standard DB maintenance (tzablespce, growth, etc...)

Regards,

Juergen