0 Replies Latest reply: Jul 10, 2018 7:45 AM by Gulshan Rohilla RSS

    Why script run time of snowflake schema is more as compared to star

    Gulshan Rohilla

      Hello everyone,

       

      we have snowflake schema in our data model which has less number of joins but on the other side if we convert the snowflake schema into star schema by using joins, so we have more number of joins in star schema so by this star schema takes more time as joins are not optimize and takes more time. can anyone clarify the above line.

       

       

      Regards

      Gulshan