Will changing semantic attributes of a secondary index trigger a rebuild of the index?

[sergiu_popa]

Hello experts,

I'm currently planning to change some semantic attributes (e.g.: definition of DB-System for which the index should be created) of a non-unique secondary index in a SAP Netweaver 740 system with an Oracle database.

Now, I'm not sure of the consequences this change might have on the existing index. Once I, for example, add HDB to the DB-Systems excluded from the creation of the index, the index will become inactive and I will have to activate it.

Once I activate the changes, should I expect that this action will trigger the re-building of the index?

Thank you and have a good day!
Sergiu

[janos_mucsi-besze · Accepted solution]

Hi Sergiu,

Anytime.

I think (almost 100% sure) that the migration is taking care of the indexes. As we all know indexes making less sense for HANA. 😉 So I am sure that SWPM and the other tools are capable of making the necessary changes for HANA.

Regards,

János

[janos_mucsi-besze]

Hi Sergui,

The index needs to be activated once again from SE11/SE14 transaction. Saving the changes does nothing on its own. But as far, normally we do not change these attributes. And even if you plan to do so, you need to talk first with the responsible application team unless you perform this change for a Z-table.

In any case, I expect this change to affect only the ABAP dictionary first, especially if these changes does not affect the actual database.

[sergiu_popa]

Hi Janos,

Thanks for your answer!
In my case we are planning an upgrade to S/4HANA and most indexes that were created in the ECC System don't make sense in a HANA DB; hence the need to exclude them from being created in a HANA DB.

I have the same feeling that this change won't affect the index as it doesn't involve the actual index definition.
Nonetheless, I do have to activate the index definition after this change, and I was concerned that the activation of the index definition would trigger a re-build of the index. That is why I raised this question here... I was hoping someone that is more experienced with such changes could confirm or not my assumption :-).

Cheers,
Sergiu