Benefit of using Autonumber() although key is already numeric?

[chriys1337]

Hi Qlik experts,

I am using a datamodel where all tables come from an SQL database and all keys are coming from there as numeric (with 6-8 digits).

Now my question is, would a additional autonumber() around all key fields bring any benefit in this scenario? Or would this end up with additional calculation / script time, but no performance benefit?

Thanks for your help!

chriys

[rwunderlich · Accepted solution]

AutoNumbered values will be sequential integers.  Sequential integers do not require a symbol table to store the field values.  Therefore an autonumbered field will use less RAM.  

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[jonathandienst]

Rob - I assume you mean: Sequential integers do NOT require a symbol table to store the field values. 

[rwunderlich]

Yes, thanks for the correction.  I updated the post. 

-Rob