Secondary Indexes after upgrade

[Former Member]

Dear Experts,

In this link http://scn.sap.com/thread/283053 I read that Thomas Jung Sir has shared that secondary indexes are lost after an upgrade whereas extension indexes are not. Also that sec indexes have to be created again manually in upgraded system.

I have upgraded from 4.7 to ECC 6.0 EHP 5.

Can you please let me know,

1) How to identify list of tables for which secondary indexes were created in 4.7 version so that I can replicate the same in ECC 6.0

2) Is there any performance criteria that I should consider before replicating the index in ECC 6.0 or as a general practice should we replicate all the indexes from 4.7 to ECC 6.0?

AWF

[former_member189725 · Accepted solution]

1.  Before you upgrade in Release SAP R/3 4.7 , go to tcode se11 , select view DD12V. Then choose Utilities --> Contents. In the selection criteria select UNIQUEFLAG not equal to X and AS4USER not equal to SAP. This would give you list of secondary indexes created by the customer. Save this list.

Also check the field DBINDEX, if this field is blank , it means the index is defined in ABAP dictionary only and does not exist in the database

After the upgrade , you can refer this list to create to secondary indexes depending on requirement.

2. Do not create secondary indexes immediately after the upgrade . Check if there is any performance issue . Also consult SAP support before creating indexes. Generally on SAP standard tables , SAP already provides required indexes.

Regards

Ratnajit

[sunny_pahuja2]

Hi,

You can check missing indexes in t-code db02old or dbacockpit. And recreate missing indexes from there.

Thanks

Sunny