Best way to work with Composite Keys?

[microwin88x]

Hello!

I have 2 different tables related by the following fields: Rate, Stratum and Month.

It is better to:

- Concatenate those 3 fields and have something like RATE&'-'STRATUM&'-'MONTH AS %KEY_RSM?

- Or use the AutoHashing? Or another thing?

Thank you!!!

[#2 · Accepted solution]

Use the autonumber function.

ex:

Autonumberhash128 (RATE&STRATUM&MONTH )

It is the best solution for the performance.

Hope this helps.

[Carlos_Reyes]

Well, I'm no expert but using Autonumber or any of its variations may improve performance but will also make it more difficult to debug this field. Perhaps you'd like to read this post from Karl Pover about this topic.

Is AutoNumber() really worth the hassle? | Harvesting Wisdom

[maxgro]

I like these 2 about syn keys

Should We Stop Worrying and Love the Synthetic Key?

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys