topic Re: Left keep and left join which one is better for performance wise? in QlikView https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881934#M655239 <HTML><HEAD></HEAD><BODY><P>Please don't clutter this site with duplicate discussions: <A href="https://community.qlik.com/thread/168128">left keep or left join which one is give better performance?</A></P></BODY></HTML> Fri, 12 Jun 2015 12:46:18 GMT Gysbert_Wassenaar 2015-06-12T12:46:18Z Left keep and left join which one is better for performance wise? https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881933#M655238 <HTML><HEAD></HEAD><BODY><P>hi ,</P><P></P><P>I use left keep and left join in qlikview.I saw the difference in datamodel leftkeep keep table separate&nbsp; in datamodel&nbsp; and left join merge the 2 tables into one.but&nbsp; I have a doubt&nbsp; which one&nbsp; give&nbsp; better performance wise.in both whether leftjoin or left keep. which one is better for performance wise? I do not know pls tell me out. which one is give&nbsp; better performance</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thankyou,</P><P></P><P></P><P>Regards</P><P>madhu.</P></BODY></HTML> Fri, 12 Jun 2015 12:34:02 GMT https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881933#M655238 2015-06-12T12:34:02Z Re: Left keep and left join which one is better for performance wise? https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881934#M655239 <HTML><HEAD></HEAD><BODY><P>Please don't clutter this site with duplicate discussions: <A href="https://community.qlik.com/thread/168128">left keep or left join which one is give better performance?</A></P></BODY></HTML> Fri, 12 Jun 2015 12:46:18 GMT https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881934#M655239 Gysbert_Wassenaar 2015-06-12T12:46:18Z Re: Left keep and left join which one is better for performance wise? https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881935#M655240 <HTML><HEAD></HEAD><BODY><P>And "Visualizations"<A href="https://community.qlik.com/thread/168128">left keep or left join which one is give better performance?</A> is not the best forum to place a question about keep/join</P></BODY></HTML> Fri, 12 Jun 2015 13:31:56 GMT https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881935#M655240 Clever_Anjos 2015-06-12T13:31:56Z Re: Left keep and left join which one is better for performance wise? https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881936#M655241 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Further reading:</P><P style="font-size: 13.3333330154419px;"><A href="https://community.qlik.com/docs/DOC-7343">Best Practices in Data Modeling.pdf</A></P><P style="font-size: 13.3333330154419px;"><A href="https://community.qlik.com/qlik-blogpost/4039">A Myth about the Number of Hops</A></P><P style="font-size: 13.3333330154419px;"><A href="https://community.qlik.com/message/360786">Performance w/ multiple fact tables - star schema vs. master link</A></P></BODY></HTML> Fri, 12 Jun 2015 13:34:27 GMT https://community.qlik.com/t5/QlikView/Left-keep-and-left-join-which-one-is-better-for-performance-wise/m-p/881936#M655241 Clever_Anjos 2015-06-12T13:34:27Z