Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Transport new index for produtive system

Former Member
0 Kudos

Hi,

Does anyone know if I need to have any special care when transporting a new index in a SAP standard table for produtive system, when the users are using the produtive system ?

Thanks,

Paulo Sousa

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Make sure the new index is activated and created in the database.

Also have the DBAs update the statistics for the table.

Rob

2 REPLIES 2

Former Member
0 Kudos

Make sure the new index is activated and created in the database.

Also have the DBAs update the statistics for the table.

Rob

Former Member
0 Kudos

Caution:

Transporting a new index for a really large table is a good way of annoying your users, and your boss as well.

That's because table will be locked. And it may last for minutes, sometimes for hours.

Good news:

There are workarounds.

For a start:

Note 334224 - Important notes for creating indexes

regards