-
Dimensional modelling is again sub divided into 2 types.
a)Star Schema - Simple & Much Faster. Denormalized form. b)Snowflake Schema - Complex with more Granularity. More normalized form.
cyberdiptikanta
- Jun 26th, 2010
Star Schema is performance wise better than Snow Flake Schema. As Star schema uses denormalise tables, so there will be less no of join as compared to Snow flake Schema.RegardsDiptikanta
shady2pac
- Oct 19th, 2008
Is not star schema better performance wise (querying) as it has less no of join due to denormalized structure? Please clarify
