- 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 pageThis 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.