Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017advantages disadvantages schema Snowflake star

0

Posted

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

1 Answer

0

Posted

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.