Answers

Question and Answer:

  Home  Data Architect

⟩ Tell me which schema is better – star or snowflake?

The choice of a schema always depends upon the project requirements & scenarios.

Since star schema is in de-normalized form, you require fewer joins for a query. The query is simple and runs faster in a star schema. Coming to the snowflake schema, since it is in normalized form, it will require a number of joins as compared to a star schema, the query will be complex and execution will be slower than star schema.

 134 views

More Questions for you: