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