Skip to Content
avatar image
Former Member

how to create missing indexes

Dear sir

I have find some missing indexes is there in T code db02

can anyone tell me how to create missing indexes and how to manage that thing frequentely

regards

krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 12, 2010 at 01:13 PM

    Hi,

    in SE12 you can activate the index. (display the index and activate it)

    Alternatively in SE14 the index can be created with the database utilty.

    (display the table, click indexes, choose your index, then create it).

    In case you have a big database table you should prefer SE14 and use

    the background option in order to avoid timeouts.

    I'm not aware of an automatism for manage this frequently. This is a

    task carried out by SAP system or database administrators.

    Kind regards,

    Hermann

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2010 at 08:54 AM

    How did you find the missing indices?

    Generally I would say, the usage of database functions which display missing indices should be done by the db admin, who should know how to create an index.

    Developers should concentrate on the indices which they find or don't find in the analysis of their applications.

    You should not create indices for tables which don't relate to your work. Sometimes it can make sense, that an index is not there.

    Siegfried

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2010 at 05:25 PM

    Hi Krishna,

    Making secondary index for database table is responsibility of the BASIS team.

    If you think that some index in missing or required then you can request BASIS team for the same.

    Do not create it on your own and without proper analysis. It is not always necessary that creation of secondary index will improve perfromance.

    Hope this helps you.

    Add comment
    10|10000 characters needed characters exceeded