Join Impact on Performance

[Anonymous]

Hello All,

I am having multiple QVDs and to create a better data model I need to join most of the tables.

Just need your help, will multiple joins impact the performance of QVS??

Regards,

Balraj Ahlawat

[Colin-Albert]

Mapping tables should help.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

[sujeetsingh]

If required then use joins .

Use keys too for auto association.

Refer this doc

Best Practices for Data Modelling

[hic]

I would question why you should join in the first place. Read more here: http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join

On performance: The join itself can take time and it might be a good idea to make the join in the DB before you create the QVDs.

HIC