SAP Knowledge Base Article - Preview

2583830 - INSERT SELECT with CASE expressions runs slow - SAP IQ

Symptom

  • INSERT IQ_TABLE2 SELECT FROM IQ_TABLE1 runs slow whatever the number of rows to be inserted.
  • Both tables are IQ tables.
  • Source table IQ_TABLE1 was created on IQ 15.4.
  • The SELECT itself completes in a few secs, while INSERT SELECT could take between 7 mins and 10 mins.
  • The SELECT column list involves CASE expressions and substring function.
  • Most of the execution time is spend between 

End of Query Block Analysis and
End of DFE Generation


Read more...

Environment

SAP IQ 16 SP11 PL13

Product

SAP IQ 16.0

Keywords

CR812581, CR#812581, 812581, performance, "End of DFE Generation",  "End of Query Block Analysis", DFE , 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.