Optimizing ASO Cube to better performance in adhoc
Hello experts,
I would like to know if I can do a better performance with refreshing and adhoc in ASO cube, it depends of the intersection is about 15/20 sec to refreshing data.
This is my order in dimensions:
And this is my dimensions from Database Properties:
and stadistics:
Any help to optimize this cube to get a better performance? maybe changing the order in dimensions?
Every night I have configured Merge and Compact Outline.
Regards!
Tagged:
0