on 03-29-2007 1:08 AM
I have couple of queries on a particular cube that run forever , i rebuilt the indexes for that
cubes fact table and regenerated the queries . some of them started executing pretty quick
whereas the others are still very slow .
The result is similar when i use listcube also
when i check sm66 it it sows that the query reads the cube fact table for a very very long time .
Is there anything that can be done ?
All suggestions welcome !!
cube has no aggregates
Oops,
Execute the query using RSRT and see the execution plan and see if anything is being missed....
A better option would be to build aggregates....
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi oops,
Why dont you build aggregates on the cube? it will considerably reduce the query run time.refreshing cube statistics and creating index definitely help in loading the cube and reading the cube but if it has got huge records, then obviously, the query run time will be high and you have to build aggregates for the cube. If you click on business intelligence in SND, then ull find many documents as how to create an aggregate under performance link. This should help you
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.