What Are The Advantages And Disadvantages Of Star And Snowflake Schem

1.	What Are The Advantages And Disadvantages Of Star And Snowflake Schema?
Answer» 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 redundancy. Snowflake Schema Disadvantages:Requires more joins to get information from LOOK up tables hence slow performance. 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 redundancy. Snowflake Schema Disadvantages:Requires more joins to get information from look up tables hence slow performance.

What Are The Advantages And Disadvantages Of Star And Snowflake Schema?

Answer»

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 redundancy.

Snowflake Schema Disadvantages:Requires more joins to get information from LOOK up tables hence slow performance.

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 redundancy.

Snowflake Schema Disadvantages:Requires more joins to get information from look up tables hence slow performance.