on ‎2005 May 11 3:21 PM
Hi BW Guru's
What are the Query Performance improvement tools , If you want make to useful than, what is activity you need to perform.
Cheers,
Bhima Chandra Sekhar G
The BW Performance Tuning Knowledge Center site on SDN is good too.
https://www.sdn.sap.com/sdn/developerareas/bi.sdn?page=bi_performance.htm
Basic tuning -
Ignoring the issue of modeling and query design, these are the basic tools to start with.
Here's the order I would tackle things -
Compression
InfoCube Aggregates
Additional Indexes - on ODS, Dim and Master Data tables
Additional indexes require an understanding of how the queries are run and to ability to understand SQL execution plans.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.