When a Secondary Index Table is really created when it is transported

[glauco]

Hi fellows.

I would like to know when really a new secondary index Z01 is created in the ZTable after transporting it.

Is it a background/assynchronus task ? When does it really start ?

best regards.

Glauco
ABAP Senior Consultant

[MarioDeFelipe]

Hello Glauco

in SE11, the index needs to have (index on all database systems)

in that case, when you activate it it will request a TR, this TR when you move it it will create the index in the target system during the transport.

if you dont want the index to be created and only the definition to be syncronized, you need to select "No database index" then it will not be creted when you transport it.

if you want to move a TR with a big index, a good approach is to create the index with database tools before, because you can parallelize and when you move the transport (with option "Index on all database systems") SAP will see that the index is created in the DB and will not re-create it.

you can check SAP note 334224 that gives an overview of this approach.

[Former Member]

Hi Glauco,

Go to SE14, utilities and then activation log.

It shows the time when the Index was activated. OR DB utility also shows all these details.

Regards,

Harish Karra