/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
Simple queries are failing with "Statement requires too much memory during query optimization" errors during peak server load times. If we rerun the queries then they run fine.
The Catalog Store Cache Size (-c) is 128m.
Read more...
Environment
SAP IQ 16.1 SP04 PL09
Product
SAP IQ 16.1
Keywords
Statement requires too much memory during query optimization Catalog Store Cache Size -c -ch -cl , 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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)