topic Re: how to create missing indexes in Application Development and Automation Discussions

how to create missing indexes

Former Member — Tue, 12 Jan 2010 12:34:03 GMT

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

Re: how to create missing indexes

HermannGahm — Tue, 12 Jan 2010 13:13:24 GMT

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

Re: how to create missing indexes

Former Member — Wed, 13 Jan 2010 08:54:12 GMT

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

Re: how to create missing indexes

Former Member — Sat, 16 Jan 2010 17:25:28 GMT

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.