Q: What are the Advantage and disadvantage of Snowflake Schema ?
Advantage of Snowflake Schema
- The main advantage of Snowflake Schema is the improvement of query performance due to minimized disk storage requirements and joining smaller lookup tables.
- It is easier to maintain.
- Increase flexibility.
Disadvantage of Snowflake Schema
- The main disadvantage of the Snowflake Schema is the additional maintenance efforts needed to the increase number of lookup tables.
- Makes the queries much more difficult to create because more tables need to be joined.