SAP Knowledge Base Article - Preview

3070870 - Query performance issue after upgrading to 16 SP11.28 from version 15.4 - SAP IQ


  • When selecting join algorithms for a right or full outer equijoin operator, if the join predicate was on varchar columns of the same declared length then the optimizer might not consider the predicate acceptable for hashing.
  • As a result, the optimizer either may not choose hash-based algorithms for the join or it could choose a hash join with a poorly-performant hash function based on a subset of the join columns. 



  • SAP IQ 16.1
  • SAP IQ 16.0 


SAP IQ 16.0 ; SAP IQ 16.1


 CR824420, CR#824420, 824420 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.