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.