SAP Knowledge Base Article - Preview

2548402 - Database performance degraded after upgrading the version of SQL Anywhere


  • After unloading and reloading a SQL Anywhere 10 database into a new database with SQL Anywhere 17 dbunload.exe, performance is poor on the new database.
  • After upgrading from Sybase 11 to Sybase 16, a query takes a long time to complete.
  • A query which took seconds to run in Sybase 11 might take multiple hours to complete in version 16.



SAP SQL Anywhere - All versions


SAP SQL Anywhere all versions


graphical plan, bad statistics, worse, rebuild, query, statistics, table scan, sequential, several hours, sqlany, sqla , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.