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.