2025102 - Table Updates are generating a high volume of forwarded rows - SAP ASE

• A test where all rows in a table containing 10,000 rows were updated in a single explicit transaction.   
• Following the update, there are almost 8,000 rows forwarded for the 10,000 rows updated.
  
  Example code:
  
  declare @x int
  select @x = 1
  begin tran
  while @x <= 10000 begin
  update processing_test
  set server_id = @x, server_alloc_no = @x+1
  where proc_number_wil = @x
  select @x=@x+1
  end
  commit
  go

Rows updated    rows forwarded
10000.000000    7691.000000

• SAP Adaptive Server Enterprise (ASE) 15.0.x
• SAP Adaptive Server Enterprise (ASE) 15.7.x
• SAP Adaptive Server Enterprise (ASE) 16.x

Transaction, Forward Transaction, Explicit Transaction , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem