There is a significant performance degradation of insert .. select statement after upgrading from IQ 15.4.
SQL has following typical structure.
insert into "owner"."table"( .. ) select .. from "owner"."table_wrk" where predicate1 = .. and predicate2 = ..;
Target table "owner"."table" is huge with row count of 5,984,731,600 and 12 HG indexes.
All indexes are rebuilt after upgrade.
Various performance tuning choices did not help.
- Lowering SORT_PINNABLE_CACHE_PERCENT.
- Toggling HGs from HG to THG.
- varchar width optimization option DML_options14=8. There are couple of large varchar columns with HG indexes.
- CORE_Options156 = ON which is a workaround for similar CR 818641
IQ 16.0 sp11 pl20+
insert select , performance , WaitForSignal_DontCareIfBusy , dfo_THGMerge , 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.