SAP Knowledge Base Article - Preview

3609602 - Incorrect Query Results with Prefetch On and DSS/MIX Optimizer Goals in SAP Adaptive Server Enterprise-ASE

Symptom

  • An issue arises when a specific query returns incorrect results while using the DSS or MIX optimizer goals with prefetch set to 'on'.
  • The issue does not occur when prefetch is set to 'off' or set to OLTP opt goal.
  • The query plan shows merge joins when prefetch is on and DSS/MIX opt goal is set.


Read more...

Environment

Sybase ASE Database Platform (non-Business Suite)-ASE

Product

SAP Adaptive Server Enterprise all versions

Keywords

SAP Adaptive Server Enterprise, Query, Incorrect Results, Prefetch On, DSS Optimizer Goal, MIX Optimizer Goal, Merge Joins. , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.