Q: I have a client that uses snowflake schemas to model his data marts. I would like to show him that star schemas have better performance to queries than snowflake schemas. Please compare the two schemas.

I do not think that you can conclusively say that snowflakes are faster the stars. I believe that when there are less joins, the performance is generally faster, hence I would say that stars are faster than snowflakes. In determining whether snowflakes are better than stars, I would look at my user community tool. For example, MicroStrategy must have a snowflake in order to be used successfully. Other tools will work better with stars. So to be fair to your client, in my opinion, I would suggest that you match the design to the tool.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access