Hi,
I have a query which is based on a Cube and this Cube gets 1 Million records each day.I need to have 6 months of Data in it.I already have aggregates defined on this Cube, which were made to improve the performance.Now i need to increase the Query performance to a more higher level.
Please suggest.
Thanks in Advance!!
Manu.