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?