Pages

Saturday 2 June 2012

Advantage and disadvantage of Snowflake Schema


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.