SAP Knowledge Base Article - Preview

2651382 - Performance drop after adding a multi-column primary key involving unsigned bigint - SAP IQ

Symptom

Consider

  • 2 table schemas A(a1, a2, ..., an) and B(b1, b2, ..., bk)
  • Table A has a primary key on 2 columns: A(a1, a2) 
  • the following query:

SELECT *
FROM A JOIN B ON a1=b1 and a2=b2

After the primary key is changed to A(a1, a3), the query performance could drop considerably.


Read more...

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

"unique HG" ; HG(U) ; pkey ; , 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 for Me (Login required).

Search for additional results

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