topic Re: Join Impact on Performance in QlikView https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633914#M1093983 <HTML><HEAD></HEAD><BODY><P>If required then use joins .</P><P>Use keys too for auto association.</P><P>Refer this doc </P><P></P><P><A href="https://community.qlik.com/docs/DOC-4556">Best Practices for Data Modelling</A></P></BODY></HTML> Thu, 15 May 2014 05:32:01 GMT sujeetsingh 2014-05-15T05:32:01Z Join Impact on Performance https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633912#M1093981 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am having multiple QVDs and to create a better data model I need to join most of the tables.</P><P></P><P>Just need your help, will multiple joins impact the performance of QVS??</P><P></P><P>Regards,</P><P>Balraj Ahlawat</P></BODY></HTML> Thu, 15 May 2014 05:25:47 GMT https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633912#M1093981 Anonymous 2014-05-15T05:25:47Z Re: Join Impact on Performance https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633913#M1093982 <HTML><HEAD></HEAD><BODY><P>Mapping tables should help.</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap">http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap</A></P></BODY></HTML> Thu, 15 May 2014 05:30:19 GMT https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633913#M1093982 Colin-Albert 2014-05-15T05:30:19Z Re: Join Impact on Performance https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633914#M1093983 <HTML><HEAD></HEAD><BODY><P>If required then use joins .</P><P>Use keys too for auto association.</P><P>Refer this doc </P><P></P><P><A href="https://community.qlik.com/docs/DOC-4556">Best Practices for Data Modelling</A></P></BODY></HTML> Thu, 15 May 2014 05:32:01 GMT https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633914#M1093983 sujeetsingh 2014-05-15T05:32:01Z Re: Join Impact on Performance https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633915#M1093984 <HTML><HEAD></HEAD><BODY><P>I would question why you should join in the first place. Read more here: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join">http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join</A></P><P></P><P>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. </P><P></P><P>HIC</P></BODY></HTML> Thu, 15 May 2014 06:50:31 GMT https://community.qlik.com/t5/QlikView/Join-Impact-on-Performance/m-p/633915#M1093984 hic 2014-05-15T06:50:31Z