cancel
Showing results for 
Search instead for 
Did you mean: 

Sequential read on Cube fact table

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member184494
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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