2053711 - parallel CREATE INDEX with DEFER_RECOVERY - SAP ASE

• CREATE INDEX operations when run in parallel (that is, including the with consumers clause), break the transaction log sequence
• A full database dump is required before the transaction log can be dumped, after a parallel CREATE INDEX operation
• Building indexes in serial does not break the transaction log sequence - however it is a very slow operation and not beneficial when large indexes are involved

In order to maintain the ASE transaction log sequence while creating indexes in parallel, use the DEFER_RECOVERY option during index creation.

• SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and above
• SAP Adaptive Server Enterprise (ASE) 16.0

create index, recovery, parallel , transaction log , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem