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.
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:
Post a Comment