Pages

Saturday 2 June 2012

When should you use a Star and when should you use Snowflake Schema

Q: When should you use a Star and when should you use Snowflake Schema ?

Star Schema :  If the performance is the priority Than go for Star Schema, Since here dimension tables are denormalized.

Snowflake Schema : If memory space is the priority than go for Snowflake Schema, since here dimension tables are normalized.

Posted by at

1 comment:

  1. Niharika Sree23 August 2021 at 22:31

    Very nice article,Thank you for sharing!!

    msbi online training
    msbi developer course
    Very nice post here thanks for it I always like and search such topics and everything connected to them.Excellent and very cool idea and the subject at the top of magnificence and I am happy to comment on this topic through which we address the idea of positive re like this.

    Msbi Online Training India
    msbi developer course

    ReplyDelete

Subscribe to: Post Comments (Atom)