Hi,all experts here,
How could we effectively improve the query performance on cubes from a client? Can we create indexes on them? Or if not, what else can we try?
Thanks a lot and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
There are a lot of things to try - partitioning, aggregations.... too much to discuss in a forums answer. Your best bet is to read the AS performance guide:
http://www.microsoft.com/technet/prodtechnol/sql/2005/ssas2005perfguide.mspx
Chris
|||Thanks a lot.
Best regards,
sql