Star schema Vs Snow schema

Star schema Vs Snow schema
Star schema – A single fact table with N number of Dimension,
all dimensions will be linked directly with a fact table.
This schema is de-normalized and results in simple join and less complex query as well as faster results.


Snow schema – Any dimensions with extended dimensions are know as snowflake schema, dimensions maybe interlinked or may have one to many relationship with other tables.
This schema is normalized and results in complex join and very complex query as well as slower results.