1. implement caching mechanism
2. use aggregates
3. use aggregate navigation
4. limit the number of initialisation blocks
5. turn off logging
6. carry out calculations in database
7. use materialized views if possible
8. use database hints
9. alter the NQSONFIG.ini parameters
http://www.oraclebidwh.com/2010/02/performance-tuning-in-obiee/
Posts
0 comments:
Post a Comment