SAP Knowledge Base Article - Preview

3290990 - Query performance issues related to view materialization – SAP ASE

Symptom

  • A query reference a view is slow, the view is in inner side of an outer join.
  • View definition has subquery.
  • Suboptimal showplan includes two related ‘Operator’:
    • ‘STORE Operator’ for view materialization.
    • ‘Scan Operator (VA = #) FROM TABLE Worktable#. From view: ViewName.’
  • The same query has a different query plan without view materialization on an older release without the fix of CR 804411|KBA 2477557.


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7 SP139 and up
  • SAP Adaptive Server Enterprise 16.0 SP02 PL06 and up
  • SAP Adaptive Server Enterprise 16.0 SP03 and up
  • SAP Adaptive Server Enterprise 16.0 SP04 and up

Product

SAP Adaptive Server Enterprise 16.0

Keywords

TF 4419, -T4419, 827616, CR 827616, CR827616, CR#827616, View materialization, STORE Operator , 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.