how to create missing indexes

[Former Member]

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

[former_member192616]

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

[former_member194613]

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

[Former Member]

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.