Skip to Content
Jul 05, 2012 at 10:11 PM

Secondary Indexes after upgrade


Dear Experts,

In this link 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?