Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Rob - I assume you mean: Sequential integers do NOT require a symbol table to store the field values.
Yes, thanks for the correction. I updated the post.
-Rob