topic Re: Synthetic keys in QlikView https://community.qlik.com/t5/QlikView/Synthetic-keys/m-p/1013473#M343714 <HTML><HEAD></HEAD><BODY><P>A synthetic key must not be wrong from a datamodel point of view and could be technically the same as if you used composite keys to resolve the synthetic keys and then you couldn't of course measure any differences. To have synthetic keys is more a kind of a bad habit and make it's difficult to read and understand the datamodel if you have many of them - so I suggest to remove them but there are of course other opnions, too - see:</P><P></P><P><A href="https://community.qlik.com/message/10279">Should We Stop Worrying and Love the Synthetic Key?</A></P><P></P><P>- Marcus</P></BODY></HTML> Tue, 12 Apr 2016 15:14:03 GMT marcus_sommer 2016-04-12T15:14:03Z Synthetic keys https://community.qlik.com/t5/QlikView/Synthetic-keys/m-p/1013471#M343712 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I had two synthetic keys in my data model and I hav removed same. But after removing I tried to compare execution time for both dashboards with and without synthetic keys. But I don't find any difference. Could you please let me how should I measure the performance change without synthetic key?</P></BODY></HTML> Tue, 12 Apr 2016 06:30:09 GMT https://community.qlik.com/t5/QlikView/Synthetic-keys/m-p/1013471#M343712 2016-04-12T06:30:09Z Re: Synthetic keys https://community.qlik.com/t5/QlikView/Synthetic-keys/m-p/1013472#M343713 <HTML><HEAD></HEAD><BODY><P>The synth key table has been replaced by your table, you can see differences when you make selections into your document</P></BODY></HTML> Tue, 12 Apr 2016 13:05:39 GMT https://community.qlik.com/t5/QlikView/Synthetic-keys/m-p/1013472#M343713 alexandros17 2016-04-12T13:05:39Z Re: Synthetic keys https://community.qlik.com/t5/QlikView/Synthetic-keys/m-p/1013473#M343714 <HTML><HEAD></HEAD><BODY><P>A synthetic key must not be wrong from a datamodel point of view and could be technically the same as if you used composite keys to resolve the synthetic keys and then you couldn't of course measure any differences. To have synthetic keys is more a kind of a bad habit and make it's difficult to read and understand the datamodel if you have many of them - so I suggest to remove them but there are of course other opnions, too - see:</P><P></P><P><A href="https://community.qlik.com/message/10279">Should We Stop Worrying and Love the Synthetic Key?</A></P><P></P><P>- Marcus</P></BODY></HTML> Tue, 12 Apr 2016 15:14:03 GMT https://community.qlik.com/t5/QlikView/Synthetic-keys/m-p/1013473#M343714 marcus_sommer 2016-04-12T15:14:03Z