SAP Knowledge Base Article - Preview

3521372 - Fail over delay when using sp_chgattribute to reset identity value - ASE

Symptom

  • Using sp_chgattribute to reset identity column
  • User table with identity column is not indexed
  • Performance problem may be experienced when fail over is performed with large table with millions of rows 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sp_chgattribute, performance, table, scan , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This 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.