Skip to Content
author's profile photo Former Member
Former Member

Extra indexes on info object attributes

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 02:50 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.