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
----------


Read more...

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 for Me (Login required).

Search for additional results

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