https://community.qlik.com/t5/Official-Support-Articles/Best-Practice-for-Synthetic-keys-Synthetic-Tables/ta-p/1712575 <P>Regarding Synthetic keys/Synthetic Tables, the first recommendation is to read through <A href="https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634" target="_self">this post created by Henric Cronström</A>.</P> <P>QlikView or Qlik Sense may end up using an excessive amount of time and/or memory when the number of composite keys/Synthetic Tables increases and depending on data amounts, table structure and other factors.</P> <P>Unfortunately, the actual limitations are virtually&nbsp;impossible to predict, which leaves only trial and error as a practical method to determine them.</P> <H3><FONT color="#339966"><STRONG>If they are UNINTENDED Synthetic keys/Synthetic Tables: </STRONG></FONT></H3> <P>Please eliminate the Synthetic keys/Synthetic Tables as much as possible</P> <H3><FONT color="#339966"><STRONG>If they are INTENDED Synthetic keys/Synthetic Tables: </STRONG></FONT></H3> <P>Please do the performance test and find out the best data model based on the testing result.</P> Mon, 22 Dec 2025 11:09:27 GMT Yoichi_Hirotake 2025-12-22T11:09:27Z https://community.qlik.com/t5/Official-Support-Articles/Best-Practice-for-Synthetic-keys-Synthetic-Tables/ta-p/1712575 <P>Regarding Synthetic keys/Synthetic Tables, the first recommendation is to read through <A href="https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634" target="_self">this post created by Henric Cronström</A>.</P> <P>QlikView or Qlik Sense may end up using an excessive amount of time and/or memory when the number of composite keys/Synthetic Tables increases and depending on data amounts, table structure and other factors.</P> <P>Unfortunately, the actual limitations are virtually&nbsp;impossible to predict, which leaves only trial and error as a practical method to determine them.</P> <H3><FONT color="#339966"><STRONG>If they are UNINTENDED Synthetic keys/Synthetic Tables: </STRONG></FONT></H3> <P>Please eliminate the Synthetic keys/Synthetic Tables as much as possible</P> <H3><FONT color="#339966"><STRONG>If they are INTENDED Synthetic keys/Synthetic Tables: </STRONG></FONT></H3> <P>Please do the performance test and find out the best data model based on the testing result.</P> Mon, 22 Dec 2025 11:09:27 GMT https://community.qlik.com/t5/Official-Support-Articles/Best-Practice-for-Synthetic-keys-Synthetic-Tables/ta-p/1712575 Yoichi_Hirotake 2025-12-22T11:09:27Z