SAP Knowledge Base Article - Preview

2280574 - sysqueryplans is huge. Can it be truncated in preparation for upgrade ? - SAP ASE

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.