- There is a business requirement to change the data type of a column from numeric(7,0) to numeric(9,0).
- Some of the tables are huge and are taking more than 48 hours.
- Tried doing straight alters and by dropping indices first and recreating them after the alters.
- But, both these methods are taking about the same time.
Can you please advise on the strategies and server config parameters we should use?
SAP Adaptive Server Enterprise
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.