SAP Knowledge Base Article - Preview

2823409 - Performance of query degraded in 16.x sp11 pl22 as compared to 15.x -- SAP IQ

Symptom

Performance of query degraded in 16.x sp11 pl22 as compared to 15.x

----------
End of DFO Generation 2019-06-04 12:03:15.286225
End of DFO Transforms 2019-06-04 12:03:15.773290
End of DFO Shadowing 2019-06-04 12:03:21.495350
End of DFO PrePrepare 2019-06-04 12:04:04.181271 <-------- huge time gap contributing to performance degradation
----------



Environment

  • IQ 16.0 SP11 PL22+
  • IQ 16.1 All

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

performance , DFO , shadowing , "many group by","many DFO", "large DFO","End of DFO PrePrepare", , 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.