I have 80 queries which query is taking so much time how can you solve it
- 1 Answers
- 1789 Views
- Rockwell, TCS, I also Faced
- E-Mail Answers
Answer Posted / Keshav
To improve the performance of slow queries in SAP BW (Business Warehouse), consider the following steps: (1) Optimize the SQL statements used in your InfoProviders and InfoCubes. (2) Reduce the amount of data fetched by implementing proper filter conditions or using aggregates. (3) Implement indexing on frequently used characteristics. (4) Analyze and optimize the report structure, especially joins and sorting logic. (5) Review the system settings, such as the number of threads and memory allocation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, I need to know anything and everything abt datamarts and thier behaviours. Please suggest any links/whitepapers/articles which explain datamarts from scratch. This is required for my admin job at hand. Appreciate your help :)
Hi friends gm to all , i had done bi with integrating planning. and I have full knowledge on integrating planing, but I don't faced any interview's in ip now, So friends have we any interview questions like Integrating planning, pls send my mail ID.
is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7
What are the exits available in HRPTDW01?
