Unknown indexes in ABAP Dictionary

[Former Member]

Hello,

Greetings!!

In DB02 i noted that i had 12 entries in missing indexes in ABAP Dictionary.

Some indexes were not there in the database. I recreated them in the DB using create in DB button.

Please let me know how to create those missing indexes.

Regards,

siddhartha.

[Former Member]

Hi Siddhartha,

Create the missing indexes using transaction SE11.

If you want please go through the below link:

http://help.sap.com/saphelp_nw2004s/helpdata/EN/8d/2d5fac955fbb43871e348257f6c49d/frameset.htm

Before you create an index check the table statistics that:

! Are the statistics current

!What is the table size now and how large was the table at the time of the last update statistics

Before you create an index, check for missing indexes using Transaction DB02.

Let me know if you any more infromation.

Thanks

Kishore