Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to take a decision on performance.

Hi gurus,

I am looking at the performance tuning and i have observed the ratio of DBsel and DBtran is very high like in some queries its more than 400 times so i am looking at creating aggregates .

My question is that how many aggregates are okay like i want to analyze how is it going to effect my loading or maintance when i am doing it for Query performance.

i have around 40 queries on my cube and i am estimating around 24 aggregates..is it okay to have 24 aggregates or else any other solution.

thanks and regards

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question