topic Re: left keep or left join which one is give better performance? in QlikView

left keep or left join which one is give better performance?

Fri, 12 Jun 2015 12:36:02 GMT

hi ,

I use left keep and left join in qlikview.I saw the difference in datamodel leftkeep keep table separate in datamodel and left join merge the 2 tables into one.but I have a doubt which one give 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 better performance

Thankyou,

Regards

madhu

Re: left keep or left join which one is give better performance?

Gysbert_Wassenaar — Fri, 12 Jun 2015 12:48:31 GMT

Left keep will be less costly during the script execution. Depending on your data model a joined table may perform better in charts and expressions than two separate linked tables.

Re: left keep or left join which one is give better performance?

Fri, 12 Jun 2015 17:44:43 GMT

Thankyou gysbert wassenaar