Symptom
- Using two identical boxes(1TB memory and 80core) with different versions of IQ
- One is SAP IQ15.4 ESD#2
- And another is SAP IQ 16.0 SP08.
- Loading the same data(one month of the table, about 1.5 million rows), on
- IQ15.4, it takes 8s
- Whereas, loading the same data into SAP IQ16.0 PL08 takes 42s.
Read more...
Environment
- SAP IQ 15.4
- SAP IQ 16.0 any release
- SAP IQ 16.1 any release
- All operating systems
Product
SAP IQ 16.0
Keywords
load, performance, DML_options8, REVERT_TO_V15_OPTIMIZER, "shadow parallelism". , KBA , BC-SYB-IQ , Sybase IQ , 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.