Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have tables and i just loaded into with and i created data model with out using any joins.
here my doubt is which schema is faster i.e star or snow with out using any joins between the tables
In general, less hops between tables needed to aggregate field values in expressions are performing better.
But there might be other aspects to think about, like memory consumption.
Have a look at this presentation for an introduction:
Hi Please check the following links:
Re: Star & snowflake schema
Re: WHat is star and snowflake schema?? ANd which is better regarding performance point of view. ??
Hope this will help you.
Hi,
Star Schema is the best, because there will be less number of joins involved. Check below links
Hi,
Star Schema is the best option for your data model. Performance wise comparing to snow flake, Star schema is best.
Hi
In my case I have three tables one fact and 2 dimenstion.the fact is connected to 2 dimenstion tables that is star.
another situation fact is connected to dimention and that dimention is connected to other dimention that is snow schma.
Here i didn't used any joins.in this situation which one faster.
Both will work faster.
Can you please attach your sample files?
If you have 2 or more dimension tables joining to link to Fact table, snowflake is what you're "forced" to implement.
In my experience, there is negligible performance differences, though "best practice" suggests Star is best, it's sometimes unavoidable to use a snowflake schema.