Star Schema vs Snowflake Schema

Star schema is preferred

Why because star schema is simple queries and logic, but snowflake schema is good for complex queries and logic.
If the table space is not enough to maintain a STAR schema then we should go for snowflake instead of STAR Schema.
I.e. The table should be spited in to multiple tables.

Eg: If you want to maintain time data in one table like year, month, day in one table in star schema, you need to spit this data into 3 tables like year, month, and day in snowflake schema.

Leave a Reply

Your email address will not be published.