How to activate an index on standard table

[former_member199632]

Hi,

I want to enable an index on a SAP Standard table.

Kindly let me know how to perform this action

SAP recommending to activating an index on LIPS table.

Thus they asking to  Activate the SAP delivered  index LIPS~VBG on table LIPS

What are the steps to activating this index?

I tried to edit this table in PRD via transaction SE11.

It says;

"System setting does not allow changes to be made to object TABL LIPS"

Then i have done the necessary settings via SCC4. After that allows me to modify this LIPS table

But then it gives out this screen.

Pls, let me know how can i make this index.

What is the correct way of doing this?

Is it create the index on DEV system and transporting to PRD   (DEV -> QAS -> PRD)

or

else directly create that in the PRD via se11

regards,

zerandib

[volker_borowski2]

Hello,

you need to generate an SCCR OBJECT KEY in Service Market place.

You need to generate the key under the installation number of sthe system you like to modify.

Once in change mode, you toggle the radio button on your first screen to

"Index on all database systems", save (this will create transport), and activate the index.

For Q and P you will only need to import the transport.

Createing indexes on huge tables might run for a while and will do an exclusive lock

on the table, so you will need to find a low activity window for the import.

Volker

[former_member199632]

Hi Volker,

That means you advising to create an index in DEV and transporting to QAS and PRD

Further you have mentioned that create the index , in a low - activity period.

Since to the production it reflecting as a transport request, you are advising this to perform this import at off-peak time. Is it.

Currently in the production, LIPS table contains around  2,000,000 entries;

How much time will it take to adjust this index

What are the other precaution actions needs to take before importing this to production

regards,

zerandib.

[Former Member]

Hi Zerandib,

Yes perform the Index TR import in non peak hours.

Hope same is tested Quality.

For a precaution take the backup of DB before doing the activity and keep ABAPer availability while doing this activity.

Regards,

Sahil

[stefan_koehler]

Hi Zerandib,

> How much time will it take to adjust this index

That depends on your I/O sub system, amount of data segment blocks (not only on amount of entries), available memory for sorting the data and so on, but 2 million entries are not that huge.

You can not modify the table while creating the index by a SAP transport, because of the CREATE INDEX statement is run without an ONLINE clause (don't know why SAP is not fixing this).

However you can run the DBMS_METADATA PL/SQL procedure on your index in the Q system and create it in production manually (with the ONLINE clause) before importing the ABAP transport request. In this case the table will not be locked.

Regards

Stefan

[volker_borowski2]

Whoops,

if I had ever taken a backup before creating an index, I would have backed up

quite a couple of TB just for the fun of it. There are many good reasons to

take additonal backups, but creating an index is definately not one of it.

Volker