2583830 - INSERT SELECT with CASE expressions runs slow - SAP IQ | SAP Knowledge Base Article

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.
  • 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.