Star Schema or Snow Flaxe schema?

[#1]

Hi All,

Which one best design approach, when creating data model  using star schema or snowflake schema, which one give best performance in QlikView?

[#2]

Hi,

Star scheme give you better performance. It includes better response time, script run time and data model is more flexible.

[#3]

Hi,

Generally Olap servers using star schema and it's provide better performance .

http://community.qlik.com/thread/63727

http://community.qlik.com/thread/11818

http://community.qlik.com/thread/84010

[#4]

Star schema gives better results especially for qlikview.why because if there is less no of joins qlikview works faster .

[#5]

Hi,

check the below table it will be helpful to u

[#6 · Accepted solution]

Hi,

To Check the below attachment copy also.it will helpful to you.

[ngulliver]

Hi,

Please have a look at this blog on perfecting your data model.

http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

Regards,

Neil