After unloading and reloading a SQL Anywhere 10 database into a new database with SQL Anywhere 17 dbunload.exe, performance is extremely terrible on the new database.
- After upgrading from Sybase 11 to Sybase 16, a query takes enormous time to complete.
- The same query which took seconds to run in Sybase 11, takes multiple hours to complete in version 16.
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 pageThis 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.