topic Qlik generated keys vs. snowflaking in QlikView https://community.qlik.com/t5/QlikView/Qlik-generated-keys-vs-snowflaking/m-p/1236639#M393268 <HTML><HEAD></HEAD><BODY><P>For 1,000,000 rows there is a column which only has 10 distinct values.</P><P></P><P>Is there any advantage to using autonumber with a child table over letting qlikview create it's own keys?</P><P></P><P>Which way is better?&nbsp; If I use autonumber will qlikview still create it's own set anyway?</P><P></P><P>What about a group of fields which have small set of combined distinct values?</P></BODY></HTML> Mon, 26 Dec 2016 19:33:14 GMT markp201 2016-12-26T19:33:14Z Qlik generated keys vs. snowflaking https://community.qlik.com/t5/QlikView/Qlik-generated-keys-vs-snowflaking/m-p/1236639#M393268 <HTML><HEAD></HEAD><BODY><P>For 1,000,000 rows there is a column which only has 10 distinct values.</P><P></P><P>Is there any advantage to using autonumber with a child table over letting qlikview create it's own keys?</P><P></P><P>Which way is better?&nbsp; If I use autonumber will qlikview still create it's own set anyway?</P><P></P><P>What about a group of fields which have small set of combined distinct values?</P></BODY></HTML> Mon, 26 Dec 2016 19:33:14 GMT https://community.qlik.com/t5/QlikView/Qlik-generated-keys-vs-snowflaking/m-p/1236639#M393268 markp201 2016-12-26T19:33:14Z