Indexing Fact and Dimension Tables

  • Is there a way to create index on fact and dimension tables in cube?

  • No. A cube uses a different storage engine than the relation model.

    Furthermore, an index is used to find the needle in the haystack. A cube is used to aggregate the haystack 🙂 Using indexes in cubes would be against what the cube is really for.

    If it is to speed up aggregations calculations, you can design aggregations in your cube.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • yeah.. indexing is basically all automated.. you don't create index per se.... because cube is really for aggregated results.. not to find a single entry (like relational index)

    to speed up query .. you go with aggregations..

    with aggregations.. you first go through the wizard.. then you use query log to perform "usage based optimization".. then you design your own..

    I usually just do usage based optimization as it's easy and to the point.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply