11-09-2011 2:49 PM
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
11-09-2011 3:04 PM
Make sure the new index is activated and created in the database.
Also have the DBAs update the statistics for the table.
Rob
11-09-2011 3:04 PM
Make sure the new index is activated and created in the database.
Also have the DBAs update the statistics for the table.
Rob
11-09-2011 3:46 PM
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