05-11-2009 9:51 AM
Hi gurus.
...for table EKPO I need a new index. What is the worst case scenario for importing a new index to a production system ? Is there any risk for problems....? Can the table end up as inactive ?
Please advice.
05-11-2009 10:43 AM
Hi,
The worst case scenario will be if the database statistics are not refreshed by the BASIS guys then the indices will not be picked up properly and eventually slowing down the reads on EKPO table of all the relevant programs.
Kindly ask the BASIS guys to refresh the database statistics once the new index has been moved to production system.
Regards,
Ankur Parab
05-11-2009 10:23 AM
hi erik,
tyr to use the standard indices , if u ahve created new index then if u transport to production ssytem
it will activate the table normally,
regards
afzal
05-11-2009 10:43 AM
Hi,
The worst case scenario will be if the database statistics are not refreshed by the BASIS guys then the indices will not be picked up properly and eventually slowing down the reads on EKPO table of all the relevant programs.
Kindly ask the BASIS guys to refresh the database statistics once the new index has been moved to production system.
Regards,
Ankur Parab
05-11-2009 10:46 AM