Thursday, 3 January 2013

What are the advantages and disadvantages of star and snowflake schema? | MicroStrategy

Star Schema Advantages: Reduces the number of joins between the tables and hence faster performance Star Schema Disadvantages:Requires Most amount of storage space.
Snowflake Schema Advantages: Minimum storage space and minimum data redudancy Snowflake Schema Disadvantages:Requires more joins to get information from look up tables hence slow performance.

No comments: