Hi all I have MDX query,I want tune that Query for that what I have to do In Query analyzer i have excution plan,using that normal proc,queries i can tune but in case of MDX how to tune Help me regarding Thnaks in Advance
Refer to the Books online section on tuing the MDX queries, http://www.sql-server-performance.com/articles/biz/optimizing_processing_p1.aspx http://www.sql-server-performance.com/articles/biz/optimizing_caching_p1.aspx