2025102 - Table Updates are generating a high volume of forwarded rows - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

A test where all rows were updated in a single explicit transaction.   There are almost 8,000 rows forwarded for the 10,000 rows updated.  There were only 10,000 rows total in the table.

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


Read more...

Environment

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

 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.