/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
- After upgrading ASE from version 16.0 to 16.1, significant performance degradation is observed when executing SQL statements containing a large number of 'INSERT <table> SELECT <scalars> UNION ALL SELECT <scalars>' when there are many union sides.
- Trace Flag 491 is enabled in both 16.1 and 16.0 servers.
- Compared to ASE 16.0, the same workload requires significantly more time to complete on ASE 16.1.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.1 SP00 PL01
Product
SAP Adaptive Server Enterprise 16.1
Keywords
Sybase, database, drop, dropped, bad performance, upgradation, server, DML, delete , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)