What Does Snowflake Schema Mean?
Techopedia Explains Snowflake Schema
- Key benefit is the progression in query performance, as it requires minimal disk storage and joins lookup tables with smaller sizes
- Offers better flexibility for interrelationships between components and dimension levels
- Easy to maintain, due to zero redundancy
- Enhances overall performance because smaller tables are coupled
Disadvantage of snowflake schemas include the following:
- Queries are more difficult because the joining of additional tables is required. This makes understanding queries more difficult.
- Requires more query execution time, due to the use of more tables
