2001052 - Why does ASE rebuild all indexes when using alter table modify or add column commands? - ASE

• Why does ASE rebuild all indexes when using alter table modify or add column commands?
• What is the reason ASE rebuilds all indexes when using alter table modify or add column commands?
• When using commands that change the table structure like 'alter table modify' or 'alter table add column', it is observed that all indexes on that table are rebuild

SAP Adaptive Server Enterprise (ASE) All Versions

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To