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.
SAP Knowledge Base Article - Preview