Reg: Recreation of Indexes

[Former Member]

Hi all,

We are facing some performance issues. According to SAP suggetion we are planning to recreate some indexes. But i never created an index before...... can anybody help in this......please sugfgest in proper way to recreate indexes....

thnx in advance

with regards

Harish

[Former Member]

Hi

To create index:

1. Go to DB02, click on Missing Indexes. Select index in next screen to create and click "Create in DB"

2. if you know the table name for which you want to create the index, go to SE14 -> table name -> Go to index -> In next screen "select create".

3. Yo have to use trx SE11 into Dev system, Enter the database table name and press

Display -> Indexes -> Create Enter index name. Choose Maintain logon language.

Enter short description and index fields.