locked
Do indexes in the relational database matter? RRS feed

  • Question

  • Hi,

     

    I ask this question because the level of the queries run in my cube are very low. in other words, they go to very detailed information. In this case according to profiler the data is read from the partition and not from aggregation. Does this mean the cube is reading the relational database and then I should be careful with indexes in there?

    Wednesday, February 20, 2008 2:09 PM

Answers

  • Only in HOLAP or ROLAP storage SSAS can read data from relational database and we can tune response with creating indexes, partition, metarialized view  etc. in relational source. For Molap data located in SSAS site , but if your query is detailed aggregate isn't used.

     

    Wednesday, February 20, 2008 4:20 PM