index creation and precautions

[Former Member]

Hi all,

There is a OSSnote to create indices on SAP standard tables like BSID and BSIK. I have tested the current hotpack level and all. the indices can be created.

what are all precautions or any thing to consider before creating the indices.

One thing creating indexes is part of ABAP or BASIS activity?

Regards

helpful answeres are rewarded.

[Former Member]

Yo have to use trx SE11 into Dev system.

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.

Then press save and create the request to transport the index to QA and

PRD.

Then press activate.

Precautions:

You can create an index and then transport it. You should transport it when your system isn't being used. You shouldn't need to create your index in SAP and in the RDBMS, that should happen automatically. You should update your statistics after creating an index to ensure it gets used by the optimiser.

__________________