Skip to Content
0
Former Member
Mar 29, 2007 at 12:08 AM

Sequential read on Cube fact table

35 Views

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