September 17, 2013 \ Ananth TM Star Schema vs Snowflake Schema Star schema is preferred Why: 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.