transport indexes created on a table?

[Former Member]

Hi All,

I have created indexes on one of the database tables (/bic/azmm_o0200 active table of ODS), is it transportable? or is it something we create in production?

if it is transportable, please explain how to transport this to QA?

Thanks,

Sirish..

[Former Member · Accepted solution]

It depends on whether you created the indices on the application side (in ODS change screen) or directly at the database level (SE14).

If created through application, these changes need to be transported. On other hand if you have created indices directly on the table in the database, they are created in manually in each system. Hope this helps!

[Former Member · Accepted solution]

Sudheer,

Thanks for the reply,

Can you please explain me how to create indexes using the ODS change mode on 2 fields (which are not keys)?

[Former Member · Accepted solution]

you need to create secondary indexes from the ODS maintenance screen. And these indexes will be transported along with the ODS to the target sys. You need not have to explicity transport them.

[Former Member]

hi Sirish,

I think you can directly create indexs on the table in production system...

Generally we won't transport these...

Hope it helps......