Query Performance Optimization

SAP Business Warehouse Query Design and Analysis

Query Performance Optimization

Optimize Query Performance
a. Performance Aspects
1. Considerations for Query Performance Improvement
2. Only Necessary Data is loaded and Displayed
3. Filters and Restrictions are created in the most efficient way
4. Use Query Performance Monitoring tools
5. Ensure that Read mode is set appropriately
6. Check the data Model
7. Design aggregates aligned to common filter requirements
8. Improve performance on the database level
b. Query Design Considerations - Resolving Common Issues
1. Too many characteristics in the initial view
2. Overlapping Filters
3. Overuse of the exclude functions
c. Query Read Mode
i. H – Query to be Read when you navigate or expand hierarchies
ii. X – without hierarchies – Query to read data during navigation
iii. X – with hierarchies
iv. A – Query to read all data at once
Demonstration: How to configure Query Read Mode
d. Monitor Performance
i. Performance Monitoring Tools – Tcode: RSRT1
Demonstration: How to Use Tracing with RSRT1 to Improve Query performance
Exercise: Optimize Query Performance

[Kunal]

Video not suitable for mobile phone view text is too small to read.