Post reply

indexes for table in Relational db, what in Mutidimensional db ?

  • December 6, 2010 at 10:40 pm

    #232155

    Hi All,

    this probably is a silly question but i am curious to know that if there exists an index for a table in Relational db to make query processing faster what exists in Mutidimensional db instead of indexes ?

    Regards,

    Amar Sale

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

  • December 10, 2010 at 4:33 am

    #1260972

    amarsale (12/6/2010)

    this probably is a silly question but i am curious to know that if there exists an index for a table in Relational db to make query processing faster what exists in Mutidimensional db instead of indexes ?

    Depends what database software you are referring to. In SSAS for example the most important storage feature is pre-aggregation of hierarchies. As a matter of detail, relational databases are multidimensional too. The term "multidimensional" can refer to any number of very different models and products.

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

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