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

Search for additional results

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