SAP Knowledge Base Article - Preview

2148490 - XI 3.1, BI 4.x: Sybase 15.x Merge Join Is Very Slow

Symptom

Sybase 15 introduced the concept of a "merge join". When enabled, queries that previously ran in a minute or seconds now take 5 minutes or more to complete.


Read more...

Environment

  • SAP BusinessObjects Enterprise XI 3.1
  • SAP BusinessObjects Business Intelligence 4.0
  • SAP BusinessObjects Business Intelligence 4.1
  • Sybase 15.0
  • Sybase 15.5
  • Sybase 15.7

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Enterprise XI 3.1 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

bi universe unv unx merge join connection sybase query queries too slow database data base db optimize speed up , KBA , BI-BIP-SL , Semantic Layer , Problem

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.