Symptom
- The sysqueryplans system table size (row count) grows and becomes very large over time.
- The very large size of sysqueryplans can impact (slow down) the steps within an upgrade process e.g. during system table updates.
- This also slows down Cross-Platform Dump and Load (XPDL) during phase2 of the cross-database conversion steps.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) all versions
Product
SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions
Keywords
exponentially, "query plans", cross, platform, abstract, plan , 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.