Symptom
-
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.
Read more...
Environment
SAP SQL Anywhere - All versions
Product
SAP SQL Anywhere all versions
Keywords
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.